# -*- coding: utf-8 -*-
#-----(1) data analysis of agriculture sector -----

import numpy as np
import pandas as pd
import matplotlib.pyplot as plt
import random

df = pd.read_csv ('C:/Users/Jeet Das/Desktop/Major Project - Indian Economy/Project ( Section 1-Indian Economy)/Section-1_Data_sheet/(02)_agriculture.csv',encoding="cp1252")

print("\n------- output data :-----------\n")
print("Agriculture data analysis:")
print("\n-----------------------------------\n")

# Question – A : get row and column numbers 

print('---------------------------------------------')
print("Dimension of the data frame = ",df.shape)
print('---------------------------------------------')

# Question – B : print column names :


print('------------------------\n Column names as follows :')
print('------------------------\n')
count = 0
for col in df.columns: 
        print(count,"-->",col)
        count = count+1
print("\n-----------------------------\n")

#Question – C : State_Name (using GROUP BY method) and no. of states :

state_names = df.groupby(['State_Name'])[['District_Name']].count()
print("---------------------------------")
print("\t states names : ")
print("-------------------------------")
print(state_names)
print("-------------------------------")
count = 0
for row in range(len(state_names)): 
        count = count+1
print("total no. of states = ",count)        
print("-----------------------------\n")


#Question-(4) Assam

print("--- State-4 : Assam -------")
df_assam = df[df.State_Name == 'Assam']
df_assam_dist = df_assam.groupby(['District_Name'])[['Crop_Year']].count()
print(df_assam_dist)

# crop year in Assam

print("---- Crop year in Assam ----")
df_assam_year = df_assam.groupby(['Crop_Year'])[['Crop_Year']].count()
print(df_assam_year)

# crop types in Assam

print("---- Crop types in Assam -----")
df_assam_crop = df_assam.groupby(['Crop'])[['Crop']].count()
print(df_assam_crop)

# details of assam : [1] BAKSA

print("---- Details of assam : [1] BAKSA -----")
df_assam_1 = df_assam[df_assam.District_Name == 'BAKSA']

# Select rows from year =( 1997 to 2014 ) and all columns between 'Area' and 'Production'

print("---------------------------------")
print("Data for Crop_Year = 1997")
print("---------------------------------")
df_assam_1_1997 = df_assam_1.loc[df_assam_1['Crop_Year'] == 1997,'Area':'Production']
df_assam_1_1997_sum = df_assam_1_1997.sum(axis = 0, skipna = True)
print(df_assam_1_1997_sum)
print("---------------------------------")
print("Data for Crop_Year = 1998")
print("---------------------------------")
df_assam_1_1998 = df_assam_1.loc[df_assam_1['Crop_Year'] == 1998,'Area':'Production']
df_assam_1_1998_sum = df_assam_1_1998.sum(axis = 0, skipna = True) 
print(df_assam_1_1998_sum)
print("---------------------------------")
print("Data for Crop_Year = 1999")
print("---------------------------------")
df_assam_1_1999 = df_assam_1.loc[df_assam_1['Crop_Year'] == 1999,'Area':'Production']
df_assam_1_1999_sum = df_assam_1_1999.sum(axis = 0, skipna = True) 
print(df_assam_1_1999_sum)
print("---------------------------------")
print("Data for Crop_Year = 2000")
print("---------------------------------")
df_assam_1_2000 = df_assam_1.loc[df_assam_1['Crop_Year'] == 2000,'Area':'Production']
df_assam_1_2000_sum = df_assam_1_2000.sum(axis = 0, skipna = True) 
print(df_assam_1_2000_sum)
print("---------------------------------")
print("Data for Crop_Year = 2001")
print("---------------------------------")
df_assam_1_2001 = df_assam_1.loc[df_assam_1['Crop_Year'] == 2001,'Area':'Production'] 
df_assam_1_2001_sum = df_assam_1_2001.sum(axis = 0, skipna = True)
print(df_assam_1_2001_sum)
print("---------------------------------")
print("Data for Crop_Year = 2002")
print("---------------------------------")
df_assam_1_2002 = df_assam_1.loc[df_assam_1['Crop_Year'] == 2002,'Area':'Production']
df_assam_1_2002_sum = df_assam_1_2002.sum(axis = 0, skipna = True) 
print(df_assam_1_2002_sum)
print("---------------------------------")
print("Data for Crop_Year = 2003")
print("---------------------------------")
df_assam_1_2003 = df_assam_1.loc[df_assam_1['Crop_Year'] == 2003,'Area':'Production']
df_assam_1_2003_sum = df_assam_1_2003.sum(axis = 0, skipna = True) 
print(df_assam_1_2003_sum)
print("---------------------------------")
print("Data for Crop_Year = 2004")
print("---------------------------------")
df_assam_1_2004 = df_assam_1.loc[df_assam_1['Crop_Year'] == 2004,'Area':'Production']
df_assam_1_2004_sum = df_assam_1_2004.sum(axis = 0, skipna = True) 
print(df_assam_1_2004_sum)
print("---------------------------------")
print("Data for Crop_Year = 2005")
print("---------------------------------")
df_assam_1_2005 = df_assam_1.loc[df_assam_1['Crop_Year'] == 2005,'Area':'Production']
df_assam_1_2005_sum = df_assam_1_2005.sum(axis = 0, skipna = True) 
print(df_assam_1_2005_sum)
print("---------------------------------")
print("Data for Crop_Year = 2006")
print("---------------------------------")
df_assam_1_2006 = df_assam_1.loc[df_assam_1['Crop_Year'] == 2006,'Area':'Production'] 
df_assam_1_2006_sum = df_assam_1_2006.sum(axis = 0, skipna = True)
print(df_assam_1_2006_sum)
print("---------------------------------")
print("Data for Crop_Year = 2007")
print("---------------------------------")
df_assam_1_2007 = df_assam_1.loc[df_assam_1['Crop_Year'] == 2007,'Area':'Production']
df_assam_1_2007_sum = df_assam_1_2007.sum(axis = 0, skipna = True) 
print(df_assam_1_2007_sum)
print("---------------------------------")
print("Data for Crop_Year = 2008")
print("---------------------------------")
df_assam_1_2008 = df_assam_1.loc[df_assam_1['Crop_Year'] == 2008,'Area':'Production']
df_assam_1_2008_sum = df_assam_1_2008.sum(axis = 0, skipna = True) 
print(df_assam_1_2008_sum)
print("---------------------------------")
print("Data for Crop_Year = 2009")
print("---------------------------------")
df_assam_1_2009 = df_assam_1.loc[df_assam_1['Crop_Year'] == 2009,'Area':'Production']
df_assam_1_2009_sum = df_assam_1_2009.sum(axis = 0, skipna = True) 
print(df_assam_1_2009_sum)
print("---------------------------------")
print("Data for Crop_Year = 2010")
print("---------------------------------")
df_assam_1_2010 = df_assam_1.loc[df_assam_1['Crop_Year'] == 2010,'Area':'Production'] 
df_assam_1_2010_sum = df_assam_1_2010.sum(axis = 0, skipna = True)
print(df_assam_1_2010_sum)
print("---------------------------------")
print("Data for Crop_Year = 2011")
print("---------------------------------")
df_assam_1_2011 = df_assam_1.loc[df_assam_1['Crop_Year'] == 2011,'Area':'Production'] 
df_assam_1_2011_sum = df_assam_1_2011.sum(axis = 0, skipna = True)
print(df_assam_1_2011_sum)
print("---------------------------------")
print("Data for Crop_Year = 2012")
print("---------------------------------")
df_assam_1_2012 = df_assam_1.loc[df_assam_1['Crop_Year'] == 2012,'Area':'Production']
df_assam_1_2012_sum = df_assam_1_2012.sum(axis = 0, skipna = True) 
print(df_assam_1_2012_sum)
print("---------------------------------")
print("Data for Crop_Year = 2013")
print("---------------------------------")
df_assam_1_2013 = df_assam_1.loc[df_assam_1['Crop_Year'] == 2013,'Area':'Production'] 
df_assam_1_2013_sum = df_assam_1_2013.sum(axis = 0, skipna = True)
print(df_assam_1_2013_sum)
print("---------------------------------")
print("Data for Crop_Year = 2014")
print("---------------------------------")
df_assam_1_2014 = df_assam_1.loc[df_assam_1['Crop_Year'] == 2014,'Area':'Production']
df_assam_1_2014_sum = df_assam_1_2014.sum(axis = 0, skipna = True) 
print(df_assam_1_2014_sum)
print("---------------------------------")
                                        
# details of assam : [2] BARPETA 

print("--- Details of Assam : [2] BARPETA ----")
df_assam_2 = df_assam[df_assam.District_Name == 'BARPETA']

# Select rows from year =( 1997 to 2014 ) and all columns between 'Area' and 'Production'

print("---------------------------------")
print("Data for Crop_Year = 1997")
print("---------------------------------")
df_assam_2_1997 = df_assam_2.loc[df_assam_2['Crop_Year'] == 1997,'Area':'Production']
df_assam_2_1997_sum = df_assam_2_1997.sum(axis = 0, skipna = True)
print(df_assam_2_1997_sum)
print("---------------------------------")
print("Data for Crop_Year = 1998")
print("---------------------------------")
df_assam_2_1998 = df_assam_2.loc[df_assam_2['Crop_Year'] == 1998,'Area':'Production']
df_assam_2_1998_sum = df_assam_2_1998.sum(axis = 0, skipna = True) 
print(df_assam_2_1998_sum)
print("---------------------------------")
print("Data for Crop_Year = 1999")
print("---------------------------------")
df_assam_2_1999 = df_assam_2.loc[df_assam_2['Crop_Year'] == 1999,'Area':'Production']
df_assam_2_1999_sum = df_assam_2_1999.sum(axis = 0, skipna = True) 
print(df_assam_2_1999_sum)
print("---------------------------------")
print("Data for Crop_Year = 2000")
print("---------------------------------")
df_assam_2_2000 = df_assam_2.loc[df_assam_2['Crop_Year'] == 2000,'Area':'Production']
df_assam_2_2000_sum = df_assam_2_2000.sum(axis = 0, skipna = True) 
print(df_assam_2_2000_sum)
print("---------------------------------")
print("Data for Crop_Year = 2001")
print("---------------------------------")
df_assam_2_2001 = df_assam_2.loc[df_assam_2['Crop_Year'] == 2001,'Area':'Production'] 
df_assam_2_2001_sum = df_assam_2_2001.sum(axis = 0, skipna = True)
print(df_assam_2_2001_sum)
print("---------------------------------")
print("Data for Crop_Year = 2002")
print("---------------------------------")
df_assam_2_2002 = df_assam_2.loc[df_assam_2['Crop_Year'] == 2002,'Area':'Production']
df_assam_2_2002_sum = df_assam_2_2002.sum(axis = 0, skipna = True) 
print(df_assam_2_2002_sum)
print("---------------------------------")
print("Data for Crop_Year = 2003")
print("---------------------------------")
df_assam_2_2003 = df_assam_2.loc[df_assam_2['Crop_Year'] == 2003,'Area':'Production']
df_assam_2_2003_sum = df_assam_2_2003.sum(axis = 0, skipna = True) 
print(df_assam_2_2003_sum)
print("---------------------------------")
print("Data for Crop_Year = 2004")
print("---------------------------------")
df_assam_2_2004 = df_assam_2.loc[df_assam_2['Crop_Year'] == 2004,'Area':'Production']
df_assam_2_2004_sum = df_assam_2_2004.sum(axis = 0, skipna = True) 
print(df_assam_2_2004_sum)
print("---------------------------------")
print("Data for Crop_Year = 2005")
print("---------------------------------")
df_assam_2_2005 = df_assam_2.loc[df_assam_2['Crop_Year'] == 2005,'Area':'Production']
df_assam_2_2005_sum = df_assam_2_2005.sum(axis = 0, skipna = True) 
print(df_assam_2_2005_sum)
print("---------------------------------")
print("Data for Crop_Year = 2006")
print("---------------------------------")
df_assam_2_2006 = df_assam_2.loc[df_assam_2['Crop_Year'] == 2006,'Area':'Production'] 
df_assam_2_2006_sum = df_assam_2_2006.sum(axis = 0, skipna = True)
print(df_assam_2_2006_sum)
print("---------------------------------")
print("Data for Crop_Year = 2007")
print("---------------------------------")
df_assam_2_2007 = df_assam_2.loc[df_assam_2['Crop_Year'] == 2007,'Area':'Production']
df_assam_2_2007_sum = df_assam_2_2007.sum(axis = 0, skipna = True) 
print(df_assam_2_2007_sum)
print("---------------------------------")
print("Data for Crop_Year = 2008")
print("---------------------------------")
df_assam_2_2008 = df_assam_2.loc[df_assam_2['Crop_Year'] == 2008,'Area':'Production']
df_assam_2_2008_sum = df_assam_2_2008.sum(axis = 0, skipna = True) 
print(df_assam_2_2008_sum)
print("---------------------------------")
print("Data for Crop_Year = 2009")
print("---------------------------------")
df_assam_2_2009 = df_assam_2.loc[df_assam_2['Crop_Year'] == 2009,'Area':'Production']
df_assam_2_2009_sum = df_assam_2_2009.sum(axis = 0, skipna = True) 
print(df_assam_2_2009_sum)
print("---------------------------------")
print("Data for Crop_Year = 2010")
print("---------------------------------")
df_assam_2_2010 = df_assam_2.loc[df_assam_2['Crop_Year'] == 2010,'Area':'Production'] 
df_assam_2_2010_sum = df_assam_2_2010.sum(axis = 0, skipna = True)
print(df_assam_2_2010_sum)
print("---------------------------------")
print("Data for Crop_Year = 2011")
print("---------------------------------")
df_assam_2_2011 = df_assam_2.loc[df_assam_2['Crop_Year'] == 2011,'Area':'Production'] 
df_assam_2_2011_sum = df_assam_2_2011.sum(axis = 0, skipna = True)
print(df_assam_2_2011_sum)
print("---------------------------------")
print("Data for Crop_Year = 2012")
print("---------------------------------")
df_assam_2_2012 = df_assam_2.loc[df_assam_2['Crop_Year'] == 2012,'Area':'Production']
df_assam_2_2012_sum = df_assam_2_2012.sum(axis = 0, skipna = True) 
print(df_assam_2_2012_sum)
print("---------------------------------")
print("Data for Crop_Year = 2013")
print("---------------------------------")
df_assam_2_2013 = df_assam_2.loc[df_assam_2['Crop_Year'] == 2013,'Area':'Production'] 
df_assam_2_2013_sum = df_assam_2_2013.sum(axis = 0, skipna = True)
print(df_assam_2_2013_sum)
print("---------------------------------")
print("Data for Crop_Year = 2014")
print("---------------------------------")
df_assam_2_2014 = df_assam_2.loc[df_assam_2['Crop_Year'] == 2014,'Area':'Production']
df_assam_2_2014_sum = df_assam_2_2014.sum(axis = 0, skipna = True) 
print(df_assam_2_2014_sum)
print("---------------------------------")
                         
# details of assam : [3] BONGAIGAON

print("----- Details of assam : [3] BONGAIGAON -----")
df_assam_3 = df_assam[df_assam.District_Name == 'BONGAIGAON']
         
# Select rows from year =( 1997 to 2014 ) and all columns between 'Area' and 'Production'

print("---------------------------------")
print("Data for Crop_Year = 1997")
print("---------------------------------")
df_assam_3_1997 = df_assam_3.loc[df_assam_3['Crop_Year'] == 1997,'Area':'Production']
df_assam_3_1997_sum = df_assam_3_1997.sum(axis = 0, skipna = True)
print(df_assam_3_1997_sum)
print("---------------------------------")
print("Data for Crop_Year = 1998")
print("---------------------------------")
df_assam_3_1998 = df_assam_3.loc[df_assam_3['Crop_Year'] == 1998,'Area':'Production']
df_assam_3_1998_sum = df_assam_3_1998.sum(axis = 0, skipna = True) 
print(df_assam_3_1998_sum)
print("---------------------------------")
print("Data for Crop_Year = 1999")
print("---------------------------------")
df_assam_3_1999 = df_assam_3.loc[df_assam_3['Crop_Year'] == 1999,'Area':'Production']
df_assam_3_1999_sum = df_assam_3_1999.sum(axis = 0, skipna = True) 
print(df_assam_3_1999_sum)
print("---------------------------------")
print("Data for Crop_Year = 2000")
print("---------------------------------")
df_assam_3_2000 = df_assam_3.loc[df_assam_3['Crop_Year'] == 2000,'Area':'Production']
df_assam_3_2000_sum = df_assam_3_2000.sum(axis = 0, skipna = True) 
print(df_assam_3_2000_sum)
print("---------------------------------")
print("Data for Crop_Year = 2001")
print("---------------------------------")
df_assam_3_2001 = df_assam_3.loc[df_assam_3['Crop_Year'] == 2001,'Area':'Production'] 
df_assam_3_2001_sum = df_assam_3_2001.sum(axis = 0, skipna = True)
print(df_assam_3_2001_sum)
print("---------------------------------")
print("Data for Crop_Year = 2002")
print("---------------------------------")
df_assam_3_2002 = df_assam_3.loc[df_assam_3['Crop_Year'] == 2002,'Area':'Production']
df_assam_3_2002_sum = df_assam_3_2002.sum(axis = 0, skipna = True) 
print(df_assam_3_2002_sum)
print("---------------------------------")
print("Data for Crop_Year = 2003")
print("---------------------------------")
df_assam_3_2003 = df_assam_3.loc[df_assam_3['Crop_Year'] == 2003,'Area':'Production']
df_assam_3_2003_sum = df_assam_3_2003.sum(axis = 0, skipna = True) 
print(df_assam_3_2003_sum)
print("---------------------------------")
print("Data for Crop_Year = 2004")
print("---------------------------------")
df_assam_3_2004 = df_assam_3.loc[df_assam_3['Crop_Year'] == 2004,'Area':'Production']
df_assam_3_2004_sum = df_assam_3_2004.sum(axis = 0, skipna = True) 
print(df_assam_3_2004_sum)
print("---------------------------------")
print("Data for Crop_Year = 2005")
print("---------------------------------")
df_assam_3_2005 = df_assam_3.loc[df_assam_3['Crop_Year'] == 2005,'Area':'Production']
df_assam_3_2005_sum = df_assam_3_2005.sum(axis = 0, skipna = True) 
print(df_assam_3_2005_sum)
print("---------------------------------")
print("Data for Crop_Year = 2006")
print("---------------------------------")
df_assam_3_2006 = df_assam_3.loc[df_assam_3['Crop_Year'] == 2006,'Area':'Production'] 
df_assam_3_2006_sum = df_assam_3_2006.sum(axis = 0, skipna = True)
print(df_assam_3_2006_sum)
print("---------------------------------")
print("Data for Crop_Year = 2007")
print("---------------------------------")
df_assam_3_2007 = df_assam_3.loc[df_assam_3['Crop_Year'] == 2007,'Area':'Production']
df_assam_3_2007_sum = df_assam_3_2007.sum(axis = 0, skipna = True) 
print(df_assam_3_2007_sum)
print("---------------------------------")
print("Data for Crop_Year = 2008")
print("---------------------------------")
df_assam_3_2008 = df_assam_3.loc[df_assam_3['Crop_Year'] == 2008,'Area':'Production']
df_assam_3_2008_sum = df_assam_3_2008.sum(axis = 0, skipna = True) 
print(df_assam_3_2008_sum)
print("---------------------------------")
print("Data for Crop_Year = 2009")
print("---------------------------------")
df_assam_3_2009 = df_assam_3.loc[df_assam_3['Crop_Year'] == 2009,'Area':'Production']
df_assam_3_2009_sum = df_assam_3_2009.sum(axis = 0, skipna = True) 
print(df_assam_3_2009_sum)
print("---------------------------------")
print("Data for Crop_Year = 2010")
print("---------------------------------")
df_assam_3_2010 = df_assam_3.loc[df_assam_3['Crop_Year'] == 2010,'Area':'Production'] 
df_assam_3_2010_sum = df_assam_3_2010.sum(axis = 0, skipna = True)
print(df_assam_3_2010_sum)
print("---------------------------------")
print("Data for Crop_Year = 2011")
print("---------------------------------")
df_assam_3_2011 = df_assam_3.loc[df_assam_3['Crop_Year'] == 2011,'Area':'Production'] 
df_assam_3_2011_sum = df_assam_3_2011.sum(axis = 0, skipna = True)
print(df_assam_3_2011_sum)
print("---------------------------------")
print("Data for Crop_Year = 2012")
print("---------------------------------")
df_assam_3_2012 = df_assam_3.loc[df_assam_3['Crop_Year'] == 2012,'Area':'Production']
df_assam_3_2012_sum = df_assam_3_2012.sum(axis = 0, skipna = True) 
print(df_assam_3_2012_sum)
print("---------------------------------")
print("Data for Crop_Year = 2013")
print("---------------------------------")
df_assam_3_2013 = df_assam_3.loc[df_assam_3['Crop_Year'] == 2013,'Area':'Production'] 
df_assam_3_2013_sum = df_assam_3_2013.sum(axis = 0, skipna = True)
print(df_assam_3_2013_sum)
print("---------------------------------")
print("Data for Crop_Year = 2014")
print("---------------------------------")
df_assam_3_2014 = df_assam_3.loc[df_assam_3['Crop_Year'] == 2014,'Area':'Production']
df_assam_3_2014_sum = df_assam_3_2014.sum(axis = 0, skipna = True) 
print(df_assam_3_2014_sum)
print("---------------------------------")
                                                                  
# details of assam : [4] CACHAR

print("---- Details of assam : [4] CACHAR ----- ")
df_assam_4 = df_assam[df_assam.District_Name == 'CACHAR']

# Select rows from year =( 1997 to 2014 ) and all columns between 'Area' and 'Production'

print("---------------------------------")
print("Data for Crop_Year = 1997")
print("---------------------------------")
df_assam_4_1997 = df_assam_4.loc[df_assam_4['Crop_Year'] == 1997,'Area':'Production']
df_assam_4_1997_sum = df_assam_4_1997.sum(axis = 0, skipna = True)
print(df_assam_4_1997_sum)
print("---------------------------------")
print("Data for Crop_Year = 1998")
print("---------------------------------")
df_assam_4_1998 = df_assam_4.loc[df_assam_4['Crop_Year'] == 1998,'Area':'Production']
df_assam_4_1998_sum = df_assam_4_1998.sum(axis = 0, skipna = True) 
print(df_assam_4_1998_sum)
print("---------------------------------")
print("Data for Crop_Year = 1999")
print("---------------------------------")
df_assam_4_1999 = df_assam_4.loc[df_assam_4['Crop_Year'] == 1999,'Area':'Production']
df_assam_4_1999_sum = df_assam_4_1999.sum(axis = 0, skipna = True) 
print(df_assam_4_1999_sum)
print("---------------------------------")
print("Data for Crop_Year = 2000")
print("---------------------------------")
df_assam_4_2000 = df_assam_4.loc[df_assam_4['Crop_Year'] == 2000,'Area':'Production']
df_assam_4_2000_sum = df_assam_4_2000.sum(axis = 0, skipna = True) 
print(df_assam_4_2000_sum)
print("---------------------------------")
print("Data for Crop_Year = 2001")
print("---------------------------------")
df_assam_4_2001 = df_assam_4.loc[df_assam_4['Crop_Year'] == 2001,'Area':'Production'] 
df_assam_4_2001_sum = df_assam_4_2001.sum(axis = 0, skipna = True)
print(df_assam_4_2001_sum)
print("---------------------------------")
print("Data for Crop_Year = 2002")
print("---------------------------------")
df_assam_4_2002 = df_assam_4.loc[df_assam_4['Crop_Year'] == 2002,'Area':'Production']
df_assam_4_2002_sum = df_assam_4_2002.sum(axis = 0, skipna = True) 
print(df_assam_4_2002_sum)
print("---------------------------------")
print("Data for Crop_Year = 2003")
print("---------------------------------")
df_assam_4_2003 = df_assam_4.loc[df_assam_4['Crop_Year'] == 2003,'Area':'Production']
df_assam_4_2003_sum = df_assam_4_2003.sum(axis = 0, skipna = True) 
print(df_assam_4_2003_sum)
print("---------------------------------")
print("Data for Crop_Year = 2004")
print("---------------------------------")
df_assam_4_2004 = df_assam_4.loc[df_assam_4['Crop_Year'] == 2004,'Area':'Production']
df_assam_4_2004_sum = df_assam_4_2004.sum(axis = 0, skipna = True) 
print(df_assam_4_2004_sum)
print("---------------------------------")
print("Data for Crop_Year = 2005")
print("---------------------------------")
df_assam_4_2005 = df_assam_4.loc[df_assam_4['Crop_Year'] == 2005,'Area':'Production']
df_assam_4_2005_sum = df_assam_4_2005.sum(axis = 0, skipna = True) 
print(df_assam_4_2005_sum)
print("---------------------------------")
print("Data for Crop_Year = 2006")
print("---------------------------------")
df_assam_4_2006 = df_assam_4.loc[df_assam_4['Crop_Year'] == 2006,'Area':'Production'] 
df_assam_4_2006_sum = df_assam_4_2006.sum(axis = 0, skipna = True)
print(df_assam_4_2006_sum)
print("---------------------------------")
print("Data for Crop_Year = 2007")
print("---------------------------------")
df_assam_4_2007 = df_assam_4.loc[df_assam_4['Crop_Year'] == 2007,'Area':'Production']
df_assam_4_2007_sum = df_assam_4_2007.sum(axis = 0, skipna = True) 
print(df_assam_4_2007_sum)
print("---------------------------------")
print("Data for Crop_Year = 2008")
print("---------------------------------")
df_assam_4_2008 = df_assam_4.loc[df_assam_4['Crop_Year'] == 2008,'Area':'Production']
df_assam_4_2008_sum = df_assam_4_2008.sum(axis = 0, skipna = True) 
print(df_assam_4_2008_sum)
print("---------------------------------")
print("Data for Crop_Year = 2009")
print("---------------------------------")
df_assam_4_2009 = df_assam_4.loc[df_assam_4['Crop_Year'] == 2009,'Area':'Production']
df_assam_4_2009_sum = df_assam_4_2009.sum(axis = 0, skipna = True) 
print(df_assam_4_2009_sum)
print("---------------------------------")
print("Data for Crop_Year = 2010")
print("---------------------------------")
df_assam_4_2010 = df_assam_4.loc[df_assam_4['Crop_Year'] == 2010,'Area':'Production'] 
df_assam_4_2010_sum = df_assam_4_2010.sum(axis = 0, skipna = True)
print(df_assam_4_2010_sum)
print("---------------------------------")
print("Data for Crop_Year = 2011")
print("---------------------------------")
df_assam_4_2011 = df_assam_4.loc[df_assam_4['Crop_Year'] == 2011,'Area':'Production'] 
df_assam_4_2011_sum = df_assam_4_2011.sum(axis = 0, skipna = True)
print(df_assam_4_2011_sum)
print("---------------------------------")
print("Data for Crop_Year = 2012")
print("---------------------------------")
df_assam_4_2012 = df_assam_4.loc[df_assam_4['Crop_Year'] == 2012,'Area':'Production']
df_assam_4_2012_sum = df_assam_4_2012.sum(axis = 0, skipna = True) 
print(df_assam_4_2012_sum)
print("---------------------------------")
print("Data for Crop_Year = 2013")
print("---------------------------------")
df_assam_4_2013 = df_assam_4.loc[df_assam_4['Crop_Year'] == 2013,'Area':'Production'] 
df_assam_4_2013_sum = df_assam_4_2013.sum(axis = 0, skipna = True)
print(df_assam_4_2013_sum)
print("---------------------------------")
print("Data for Crop_Year = 2014")
print("---------------------------------")
df_assam_4_2014 = df_assam_4.loc[df_assam_4['Crop_Year'] == 2014,'Area':'Production']
df_assam_4_2014_sum = df_assam_4_2014.sum(axis = 0, skipna = True) 
print(df_assam_4_2014_sum)
print("---------------------------------")                          
                                             
# details of assam : [5] CHIRANG

print("---- Details of assam : [5] CHIRANG -----")
df_assam_5 = df_assam[df_assam.District_Name == 'CHIRANG']
              
# Select rows from year =( 1997 to 2014 ) and all columns between 'Area' and 'Production'

print("---------------------------------")
print("Data for Crop_Year = 1997")
print("---------------------------------")
df_assam_5_1997 = df_assam_5.loc[df_assam_5['Crop_Year'] == 1997,'Area':'Production']
df_assam_5_1997_sum = df_assam_5_1997.sum(axis = 0, skipna = True)
print(df_assam_5_1997_sum)
print("---------------------------------")
print("Data for Crop_Year = 1998")
print("---------------------------------")
df_assam_5_1998 = df_assam_5.loc[df_assam_5['Crop_Year'] == 1998,'Area':'Production']
df_assam_5_1998_sum = df_assam_5_1998.sum(axis = 0, skipna = True) 
print(df_assam_5_1998_sum)
print("---------------------------------")
print("Data for Crop_Year = 1999")
print("---------------------------------")
df_assam_5_1999 = df_assam_5.loc[df_assam_5['Crop_Year'] == 1999,'Area':'Production']
df_assam_5_1999_sum = df_assam_5_1999.sum(axis = 0, skipna = True) 
print(df_assam_5_1999_sum)
print("---------------------------------")
print("Data for Crop_Year = 2000")
print("---------------------------------")
df_assam_5_2000 = df_assam_5.loc[df_assam_5['Crop_Year'] == 2000,'Area':'Production']
df_assam_5_2000_sum = df_assam_5_2000.sum(axis = 0, skipna = True) 
print(df_assam_5_2000_sum)
print("---------------------------------")
print("Data for Crop_Year = 2001")
print("---------------------------------")
df_assam_5_2001 = df_assam_5.loc[df_assam_5['Crop_Year'] == 2001,'Area':'Production'] 
df_assam_5_2001_sum = df_assam_5_2001.sum(axis = 0, skipna = True)
print(df_assam_5_2001_sum)
print("---------------------------------")
print("Data for Crop_Year = 2002")
print("---------------------------------")
df_assam_5_2002 = df_assam_5.loc[df_assam_5['Crop_Year'] == 2002,'Area':'Production']
df_assam_5_2002_sum = df_assam_5_2002.sum(axis = 0, skipna = True) 
print(df_assam_5_2002_sum)
print("---------------------------------")
print("Data for Crop_Year = 2003")
print("---------------------------------")
df_assam_5_2003 = df_assam_5.loc[df_assam_5['Crop_Year'] == 2003,'Area':'Production']
df_assam_5_2003_sum = df_assam_5_2003.sum(axis = 0, skipna = True) 
print(df_assam_5_2003_sum)
print("---------------------------------")
print("Data for Crop_Year = 2004")
print("---------------------------------")
df_assam_5_2004 = df_assam_5.loc[df_assam_5['Crop_Year'] == 2004,'Area':'Production']
df_assam_5_2004_sum = df_assam_5_2004.sum(axis = 0, skipna = True) 
print(df_assam_5_2004_sum)
print("---------------------------------")
print("Data for Crop_Year = 2005")
print("---------------------------------")
df_assam_5_2005 = df_assam_5.loc[df_assam_5['Crop_Year'] == 2005,'Area':'Production']
df_assam_5_2005_sum = df_assam_5_2005.sum(axis = 0, skipna = True) 
print(df_assam_5_2005_sum)
print("---------------------------------")
print("Data for Crop_Year = 2006")
print("---------------------------------")
df_assam_5_2006 = df_assam_5.loc[df_assam_5['Crop_Year'] == 2006,'Area':'Production'] 
df_assam_5_2006_sum = df_assam_5_2006.sum(axis = 0, skipna = True)
print(df_assam_5_2006_sum)
print("---------------------------------")
print("Data for Crop_Year = 2007")
print("---------------------------------")
df_assam_5_2007 = df_assam_5.loc[df_assam_5['Crop_Year'] == 2007,'Area':'Production']
df_assam_5_2007_sum = df_assam_5_2007.sum(axis = 0, skipna = True) 
print(df_assam_5_2007_sum)
print("---------------------------------")
print("Data for Crop_Year = 2008")
print("---------------------------------")
df_assam_5_2008 = df_assam_5.loc[df_assam_5['Crop_Year'] == 2008,'Area':'Production']
df_assam_5_2008_sum = df_assam_5_2008.sum(axis = 0, skipna = True) 
print(df_assam_5_2008_sum)
print("---------------------------------")
print("Data for Crop_Year = 2009")
print("---------------------------------")
df_assam_5_2009 = df_assam_5.loc[df_assam_5['Crop_Year'] == 2009,'Area':'Production']
df_assam_5_2009_sum = df_assam_5_2009.sum(axis = 0, skipna = True) 
print(df_assam_5_2009_sum)
print("---------------------------------")
print("Data for Crop_Year = 2010")
print("---------------------------------")
df_assam_5_2010 = df_assam_5.loc[df_assam_5['Crop_Year'] == 2010,'Area':'Production'] 
df_assam_5_2010_sum = df_assam_5_2010.sum(axis = 0, skipna = True)
print(df_assam_5_2010_sum)
print("---------------------------------")
print("Data for Crop_Year = 2011")
print("---------------------------------")
df_assam_5_2011 = df_assam_5.loc[df_assam_5['Crop_Year'] == 2011,'Area':'Production'] 
df_assam_5_2011_sum = df_assam_5_2011.sum(axis = 0, skipna = True)
print(df_assam_5_2011_sum)
print("---------------------------------")
print("Data for Crop_Year = 2012")
print("---------------------------------")
df_assam_5_2012 = df_assam_5.loc[df_assam_5['Crop_Year'] == 2012,'Area':'Production']
df_assam_5_2012_sum = df_assam_5_2012.sum(axis = 0, skipna = True) 
print(df_assam_5_2012_sum)
print("---------------------------------")
print("Data for Crop_Year = 2013")
print("---------------------------------")
df_assam_5_2013 = df_assam_5.loc[df_assam_5['Crop_Year'] == 2013,'Area':'Production'] 
df_assam_5_2013_sum = df_assam_5_2013.sum(axis = 0, skipna = True)
print(df_assam_5_2013_sum)
print("---------------------------------")
print("Data for Crop_Year = 2014")
print("---------------------------------")
df_assam_5_2014 = df_assam_5.loc[df_assam_5['Crop_Year'] == 2014,'Area':'Production']
df_assam_5_2014_sum = df_assam_5_2014.sum(axis = 0, skipna = True) 
print(df_assam_5_2014_sum)
print("---------------------------------")
                                                                                    
# details of assam : [6] DARRANG

print("----- Details of assam : [6] DARRANG -----")
df_assam_6 = df_assam[df_assam.District_Name == 'DARRANG']

# Select rows from year =( 1997 to 2014 ) and all columns between 'Area' and 'Production'

print("---------------------------------")
print("Data for Crop_Year = 1997")
print("---------------------------------")
df_assam_6_1997 = df_assam_6.loc[df_assam_6['Crop_Year'] == 1997,'Area':'Production']
df_assam_6_1997_sum = df_assam_6_1997.sum(axis = 0, skipna = True)
print(df_assam_6_1997_sum)
print("---------------------------------")
print("Data for Crop_Year = 1998")
print("---------------------------------")
df_assam_6_1998 = df_assam_6.loc[df_assam_6['Crop_Year'] == 1998,'Area':'Production']
df_assam_6_1998_sum = df_assam_6_1998.sum(axis = 0, skipna = True) 
print(df_assam_6_1998_sum)
print("---------------------------------")
print("Data for Crop_Year = 1999")
print("---------------------------------")
df_assam_6_1999 = df_assam_6.loc[df_assam_6['Crop_Year'] == 1999,'Area':'Production']
df_assam_6_1999_sum = df_assam_6_1999.sum(axis = 0, skipna = True) 
print(df_assam_6_1999_sum)
print("---------------------------------")
print("Data for Crop_Year = 2000")
print("---------------------------------")
df_assam_6_2000 = df_assam_6.loc[df_assam_6['Crop_Year'] == 2000,'Area':'Production']
df_assam_6_2000_sum = df_assam_6_2000.sum(axis = 0, skipna = True) 
print(df_assam_6_2000_sum)
print("---------------------------------")
print("Data for Crop_Year = 2001")
print("---------------------------------")
df_assam_6_2001 = df_assam_6.loc[df_assam_6['Crop_Year'] == 2001,'Area':'Production'] 
df_assam_6_2001_sum = df_assam_6_2001.sum(axis = 0, skipna = True)
print(df_assam_6_2001_sum)
print("---------------------------------")
print("Data for Crop_Year = 2002")
print("---------------------------------")
df_assam_6_2002 = df_assam_6.loc[df_assam_6['Crop_Year'] == 2002,'Area':'Production']
df_assam_6_2002_sum = df_assam_6_2002.sum(axis = 0, skipna = True) 
print(df_assam_6_2002_sum)
print("---------------------------------")
print("Data for Crop_Year = 2003")
print("---------------------------------")
df_assam_6_2003 = df_assam_6.loc[df_assam_6['Crop_Year'] == 2003,'Area':'Production']
df_assam_6_2003_sum = df_assam_6_2003.sum(axis = 0, skipna = True) 
print(df_assam_6_2003_sum)
print("---------------------------------")
print("Data for Crop_Year = 2004")
print("---------------------------------")
df_assam_6_2004 = df_assam_6.loc[df_assam_6['Crop_Year'] == 2004,'Area':'Production']
df_assam_6_2004_sum = df_assam_6_2004.sum(axis = 0, skipna = True) 
print(df_assam_6_2004_sum)
print("---------------------------------")
print("Data for Crop_Year = 2005")
print("---------------------------------")
df_assam_6_2005 = df_assam_6.loc[df_assam_6['Crop_Year'] == 2005,'Area':'Production']
df_assam_6_2005_sum = df_assam_6_2005.sum(axis = 0, skipna = True) 
print(df_assam_6_2005_sum)
print("---------------------------------")
print("Data for Crop_Year = 2006")
print("---------------------------------")
df_assam_6_2006 = df_assam_6.loc[df_assam_6['Crop_Year'] == 2006,'Area':'Production'] 
df_assam_6_2006_sum = df_assam_6_2006.sum(axis = 0, skipna = True)
print(df_assam_6_2006_sum)
print("---------------------------------")
print("Data for Crop_Year = 2007")
print("---------------------------------")
df_assam_6_2007 = df_assam_6.loc[df_assam_6['Crop_Year'] == 2007,'Area':'Production']
df_assam_6_2007_sum = df_assam_6_2007.sum(axis = 0, skipna = True) 
print(df_assam_6_2007_sum)
print("---------------------------------")
print("Data for Crop_Year = 2008")
print("---------------------------------")
df_assam_6_2008 = df_assam_6.loc[df_assam_6['Crop_Year'] == 2008,'Area':'Production']
df_assam_6_2008_sum = df_assam_6_2008.sum(axis = 0, skipna = True) 
print(df_assam_6_2008_sum)
print("---------------------------------")
print("Data for Crop_Year = 2009")
print("---------------------------------")
df_assam_6_2009 = df_assam_6.loc[df_assam_6['Crop_Year'] == 2009,'Area':'Production']
df_assam_6_2009_sum = df_assam_6_2009.sum(axis = 0, skipna = True) 
print(df_assam_6_2009_sum)
print("---------------------------------")
print("Data for Crop_Year = 2010")
print("---------------------------------")
df_assam_6_2010 = df_assam_6.loc[df_assam_6['Crop_Year'] == 2010,'Area':'Production'] 
df_assam_6_2010_sum = df_assam_6_2010.sum(axis = 0, skipna = True)
print(df_assam_6_2010_sum)
print("---------------------------------")
print("Data for Crop_Year = 2011")
print("---------------------------------")
df_assam_6_2011 = df_assam_6.loc[df_assam_6['Crop_Year'] == 2011,'Area':'Production'] 
df_assam_6_2011_sum = df_assam_6_2011.sum(axis = 0, skipna = True)
print(df_assam_6_2011_sum)
print("---------------------------------")
print("Data for Crop_Year = 2012")
print("---------------------------------")
df_assam_6_2012 = df_assam_6.loc[df_assam_6['Crop_Year'] == 2012,'Area':'Production']
df_assam_6_2012_sum = df_assam_6_2012.sum(axis = 0, skipna = True) 
print(df_assam_6_2012_sum)
print("---------------------------------")
print("Data for Crop_Year = 2013")
print("---------------------------------")
df_assam_6_2013 = df_assam_6.loc[df_assam_6['Crop_Year'] == 2013,'Area':'Production'] 
df_assam_6_2013_sum = df_assam_6_2013.sum(axis = 0, skipna = True)
print(df_assam_6_2013_sum)
print("---------------------------------")
print("Data for Crop_Year = 2014")
print("---------------------------------")
df_assam_6_2014 = df_assam_6.loc[df_assam_6['Crop_Year'] == 2014,'Area':'Production']
df_assam_6_2014_sum = df_assam_6_2014.sum(axis = 0, skipna = True) 
print(df_assam_6_2014_sum)
print("---------------------------------")              
                                          
# details of assam : [7] DHEMAJI 

print("----- Details of assam : [7] DHEMAJI ----")
df_assam_7 = df_assam[df_assam.District_Name == 'DHEMAJI']

# Select rows from year =( 1997 to 2014 ) and all columns between 'Area' and 'Production'

print("---------------------------------")
print("Data for Crop_Year = 1997")
print("---------------------------------")
df_assam_7_1997 = df_assam_7.loc[df_assam_7['Crop_Year'] == 1997,'Area':'Production']
df_assam_7_1997_sum = df_assam_7_1997.sum(axis = 0, skipna = True)
print(df_assam_7_1997_sum)
print("---------------------------------")
print("Data for Crop_Year = 1998")
print("---------------------------------")
df_assam_7_1998 = df_assam_7.loc[df_assam_7['Crop_Year'] == 1998,'Area':'Production']
df_assam_7_1998_sum = df_assam_7_1998.sum(axis = 0, skipna = True) 
print(df_assam_7_1998_sum)
print("---------------------------------")
print("Data for Crop_Year = 1999")
print("---------------------------------")
df_assam_7_1999 = df_assam_7.loc[df_assam_7['Crop_Year'] == 1999,'Area':'Production']
df_assam_7_1999_sum = df_assam_7_1999.sum(axis = 0, skipna = True) 
print(df_assam_7_1999_sum)
print("---------------------------------")
print("Data for Crop_Year = 2000")
print("---------------------------------")
df_assam_7_2000 = df_assam_7.loc[df_assam_7['Crop_Year'] == 2000,'Area':'Production']
df_assam_7_2000_sum = df_assam_7_2000.sum(axis = 0, skipna = True) 
print(df_assam_7_2000_sum)
print("---------------------------------")
print("Data for Crop_Year = 2001")
print("---------------------------------")
df_assam_7_2001 = df_assam_7.loc[df_assam_7['Crop_Year'] == 2001,'Area':'Production'] 
df_assam_7_2001_sum = df_assam_7_2001.sum(axis = 0, skipna = True)
print(df_assam_7_2001_sum)
print("---------------------------------")
print("Data for Crop_Year = 2002")
print("---------------------------------")
df_assam_7_2002 = df_assam_7.loc[df_assam_7['Crop_Year'] == 2002,'Area':'Production']
df_assam_7_2002_sum = df_assam_7_2002.sum(axis = 0, skipna = True) 
print(df_assam_7_2002_sum)
print("---------------------------------")
print("Data for Crop_Year = 2003")
print("---------------------------------")
df_assam_7_2003 = df_assam_7.loc[df_assam_7['Crop_Year'] == 2003,'Area':'Production']
df_assam_7_2003_sum = df_assam_7_2003.sum(axis = 0, skipna = True) 
print(df_assam_7_2003_sum)
print("---------------------------------")
print("Data for Crop_Year = 2004")
print("---------------------------------")
df_assam_7_2004 = df_assam_7.loc[df_assam_7['Crop_Year'] == 2004,'Area':'Production']
df_assam_7_2004_sum = df_assam_7_2004.sum(axis = 0, skipna = True) 
print(df_assam_7_2004_sum)
print("---------------------------------")
print("Data for Crop_Year = 2005")
print("---------------------------------")
df_assam_7_2005 = df_assam_7.loc[df_assam_7['Crop_Year'] == 2005,'Area':'Production']
df_assam_7_2005_sum = df_assam_7_2005.sum(axis = 0, skipna = True) 
print(df_assam_7_2005_sum)
print("---------------------------------")
print("Data for Crop_Year = 2006")
print("---------------------------------")
df_assam_7_2006 = df_assam_7.loc[df_assam_7['Crop_Year'] == 2006,'Area':'Production'] 
df_assam_7_2006_sum = df_assam_7_2006.sum(axis = 0, skipna = True)
print(df_assam_7_2006_sum)
print("---------------------------------")
print("Data for Crop_Year = 2007")
print("---------------------------------")
df_assam_7_2007 = df_assam_7.loc[df_assam_7['Crop_Year'] == 2007,'Area':'Production']
df_assam_7_2007_sum = df_assam_7_2007.sum(axis = 0, skipna = True) 
print(df_assam_7_2007_sum)
print("---------------------------------")
print("Data for Crop_Year = 2008")
print("---------------------------------")
df_assam_7_2008 = df_assam_7.loc[df_assam_7['Crop_Year'] == 2008,'Area':'Production']
df_assam_7_2008_sum = df_assam_7_2008.sum(axis = 0, skipna = True) 
print(df_assam_7_2008_sum)
print("---------------------------------")
print("Data for Crop_Year = 2009")
print("---------------------------------")
df_assam_7_2009 = df_assam_7.loc[df_assam_7['Crop_Year'] == 2009,'Area':'Production']
df_assam_7_2009_sum = df_assam_7_2009.sum(axis = 0, skipna = True) 
print(df_assam_7_2009_sum)
print("---------------------------------")
print("Data for Crop_Year = 2010")
print("---------------------------------")
df_assam_7_2010 = df_assam_7.loc[df_assam_7['Crop_Year'] == 2010,'Area':'Production'] 
df_assam_7_2010_sum = df_assam_7_2010.sum(axis = 0, skipna = True)
print(df_assam_7_2010_sum)
print("---------------------------------")
print("Data for Crop_Year = 2011")
print("---------------------------------")
df_assam_7_2011 = df_assam_7.loc[df_assam_7['Crop_Year'] == 2011,'Area':'Production'] 
df_assam_7_2011_sum = df_assam_7_2011.sum(axis = 0, skipna = True)
print(df_assam_7_2011_sum)
print("---------------------------------")
print("Data for Crop_Year = 2012")
print("---------------------------------")
df_assam_7_2012 = df_assam_7.loc[df_assam_7['Crop_Year'] == 2012,'Area':'Production']
df_assam_7_2012_sum = df_assam_7_2012.sum(axis = 0, skipna = True) 
print(df_assam_7_2012_sum)
print("---------------------------------")
print("Data for Crop_Year = 2013")
print("---------------------------------")
df_assam_7_2013 = df_assam_7.loc[df_assam_7['Crop_Year'] == 2013,'Area':'Production'] 
df_assam_7_2013_sum = df_assam_7_2013.sum(axis = 0, skipna = True)
print(df_assam_7_2013_sum)
print("---------------------------------")
print("Data for Crop_Year = 2014")
print("---------------------------------")
df_assam_7_2014 = df_assam_7.loc[df_assam_7['Crop_Year'] == 2014,'Area':'Production']
df_assam_7_2014_sum = df_assam_7_2014.sum(axis = 0, skipna = True) 
print(df_assam_7_2014_sum)
print("---------------------------------")
                 
# details of assam : [8] DHUBRI

print("---- Details of assam : [8] DHUBRI ------")
df_assam_8 = df_assam[df_assam.District_Name == 'DHUBRI']
                               
# Select rows from year =( 1997 to 2014 ) and all columns between 'Area' and 'Production'

print("---------------------------------")
print("Data for Crop_Year = 1997")
print("---------------------------------")
df_assam_8_1997 = df_assam_8.loc[df_assam_8['Crop_Year'] == 1997,'Area':'Production']
df_assam_8_1997_sum = df_assam_8_1997.sum(axis = 0, skipna = True)
print(df_assam_8_1997_sum)
print("---------------------------------")
print("Data for Crop_Year = 1998")
print("---------------------------------")
df_assam_8_1998 = df_assam_8.loc[df_assam_8['Crop_Year'] == 1998,'Area':'Production']
df_assam_8_1998_sum = df_assam_8_1998.sum(axis = 0, skipna = True) 
print(df_assam_8_1998_sum)
print("---------------------------------")
print("Data for Crop_Year = 1999")
print("---------------------------------")
df_assam_8_1999 = df_assam_8.loc[df_assam_8['Crop_Year'] == 1999,'Area':'Production']
df_assam_8_1999_sum = df_assam_8_1999.sum(axis = 0, skipna = True) 
print(df_assam_8_1999_sum)
print("---------------------------------")
print("Data for Crop_Year = 2000")
print("---------------------------------")
df_assam_8_2000 = df_assam_8.loc[df_assam_8['Crop_Year'] == 2000,'Area':'Production']
df_assam_8_2000_sum = df_assam_8_2000.sum(axis = 0, skipna = True) 
print(df_assam_8_2000_sum)
print("---------------------------------")
print("Data for Crop_Year = 2001")
print("---------------------------------")
df_assam_8_2001 = df_assam_8.loc[df_assam_8['Crop_Year'] == 2001,'Area':'Production'] 
df_assam_8_2001_sum = df_assam_8_2001.sum(axis = 0, skipna = True)
print(df_assam_8_2001_sum)
print("---------------------------------")
print("Data for Crop_Year = 2002")
print("---------------------------------")
df_assam_8_2002 = df_assam_8.loc[df_assam_8['Crop_Year'] == 2002,'Area':'Production']
df_assam_8_2002_sum = df_assam_8_2002.sum(axis = 0, skipna = True) 
print(df_assam_8_2002_sum)
print("---------------------------------")
print("Data for Crop_Year = 2003")
print("---------------------------------")
df_assam_8_2003 = df_assam_8.loc[df_assam_8['Crop_Year'] == 2003,'Area':'Production']
df_assam_8_2003_sum = df_assam_8_2003.sum(axis = 0, skipna = True) 
print(df_assam_8_2003_sum)
print("---------------------------------")
print("Data for Crop_Year = 2004")
print("---------------------------------")
df_assam_8_2004 = df_assam_8.loc[df_assam_8['Crop_Year'] == 2004,'Area':'Production']
df_assam_8_2004_sum = df_assam_8_2004.sum(axis = 0, skipna = True) 
print(df_assam_8_2004_sum)
print("---------------------------------")
print("Data for Crop_Year = 2005")
print("---------------------------------")
df_assam_8_2005 = df_assam_8.loc[df_assam_8['Crop_Year'] == 2005,'Area':'Production']
df_assam_8_2005_sum = df_assam_8_2005.sum(axis = 0, skipna = True) 
print(df_assam_8_2005_sum)
print("---------------------------------")
print("Data for Crop_Year = 2006")
print("---------------------------------")
df_assam_8_2006 = df_assam_8.loc[df_assam_8['Crop_Year'] == 2006,'Area':'Production'] 
df_assam_8_2006_sum = df_assam_8_2006.sum(axis = 0, skipna = True)
print(df_assam_8_2006_sum)
print("---------------------------------")
print("Data for Crop_Year = 2007")
print("---------------------------------")
df_assam_8_2007 = df_assam_8.loc[df_assam_8['Crop_Year'] == 2007,'Area':'Production']
df_assam_8_2007_sum = df_assam_8_2007.sum(axis = 0, skipna = True) 
print(df_assam_8_2007_sum)
print("---------------------------------")
print("Data for Crop_Year = 2008")
print("---------------------------------")
df_assam_8_2008 = df_assam_8.loc[df_assam_8['Crop_Year'] == 2008,'Area':'Production']
df_assam_8_2008_sum = df_assam_8_2008.sum(axis = 0, skipna = True) 
print(df_assam_8_2008_sum)
print("---------------------------------")
print("Data for Crop_Year = 2009")
print("---------------------------------")
df_assam_8_2009 = df_assam_8.loc[df_assam_8['Crop_Year'] == 2009,'Area':'Production']
df_assam_8_2009_sum = df_assam_8_2009.sum(axis = 0, skipna = True) 
print(df_assam_8_2009_sum)
print("---------------------------------")
print("Data for Crop_Year = 2010")
print("---------------------------------")
df_assam_8_2010 = df_assam_8.loc[df_assam_8['Crop_Year'] == 2010,'Area':'Production'] 
df_assam_8_2010_sum = df_assam_8_2010.sum(axis = 0, skipna = True)
print(df_assam_8_2010_sum)
print("---------------------------------")
print("Data for Crop_Year = 2011")
print("---------------------------------")
df_assam_8_2011 = df_assam_8.loc[df_assam_8['Crop_Year'] == 2011,'Area':'Production'] 
df_assam_8_2011_sum = df_assam_8_2011.sum(axis = 0, skipna = True)
print(df_assam_8_2011_sum)
print("---------------------------------")
print("Data for Crop_Year = 2012")
print("---------------------------------")
df_assam_8_2012 = df_assam_8.loc[df_assam_8['Crop_Year'] == 2012,'Area':'Production']
df_assam_8_2012_sum = df_assam_8_2012.sum(axis = 0, skipna = True) 
print(df_assam_8_2012_sum)
print("---------------------------------")
print("Data for Crop_Year = 2013")
print("---------------------------------")
df_assam_8_2013 = df_assam_8.loc[df_assam_8['Crop_Year'] == 2013,'Area':'Production'] 
df_assam_8_2013_sum = df_assam_8_2013.sum(axis = 0, skipna = True)
print(df_assam_8_2013_sum)
print("---------------------------------")
print("Data for Crop_Year = 2014")
print("---------------------------------")
df_assam_8_2014 = df_assam_8.loc[df_assam_8['Crop_Year'] == 2014,'Area':'Production']
df_assam_8_2014_sum = df_assam_8_2014.sum(axis = 0, skipna = True) 
print(df_assam_8_2014_sum)
print("---------------------------------")                               
                               
# details of assam : [9] DIBRUGARH 

print("----- Details of assam : [9] DIBRUGARH -----")
df_assam_9 = df_assam[df_assam.District_Name == 'DIBRUGARH']

# Select rows from year =( 1997 to 2014 ) and all columns between 'Area' and 'Production'

print("---------------------------------")
print("Data for Crop_Year = 1997")
print("---------------------------------")
df_assam_9_1997 = df_assam_9.loc[df_assam_9['Crop_Year'] == 1997,'Area':'Production']
df_assam_9_1997_sum = df_assam_9_1997.sum(axis = 0, skipna = True)
print(df_assam_9_1997_sum)
print("---------------------------------")
print("Data for Crop_Year = 1998")
print("---------------------------------")
df_assam_9_1998 = df_assam_9.loc[df_assam_9['Crop_Year'] == 1998,'Area':'Production']
df_assam_9_1998_sum = df_assam_9_1998.sum(axis = 0, skipna = True) 
print(df_assam_9_1998_sum)
print("---------------------------------")
print("Data for Crop_Year = 1999")
print("---------------------------------")
df_assam_9_1999 = df_assam_9.loc[df_assam_9['Crop_Year'] == 1999,'Area':'Production']
df_assam_9_1999_sum = df_assam_9_1999.sum(axis = 0, skipna = True) 
print(df_assam_9_1999_sum)
print("---------------------------------")
print("Data for Crop_Year = 2000")
print("---------------------------------")
df_assam_9_2000 = df_assam_9.loc[df_assam_9['Crop_Year'] == 2000,'Area':'Production']
df_assam_9_2000_sum = df_assam_9_2000.sum(axis = 0, skipna = True) 
print(df_assam_9_2000_sum)
print("---------------------------------")
print("Data for Crop_Year = 2001")
print("---------------------------------")
df_assam_9_2001 = df_assam_9.loc[df_assam_9['Crop_Year'] == 2001,'Area':'Production'] 
df_assam_9_2001_sum = df_assam_9_2001.sum(axis = 0, skipna = True)
print(df_assam_9_2001_sum)
print("---------------------------------")
print("Data for Crop_Year = 2002")
print("---------------------------------")
df_assam_9_2002 = df_assam_9.loc[df_assam_9['Crop_Year'] == 2002,'Area':'Production']
df_assam_9_2002_sum = df_assam_9_2002.sum(axis = 0, skipna = True) 
print(df_assam_9_2002_sum)
print("---------------------------------")
print("Data for Crop_Year = 2003")
print("---------------------------------")
df_assam_9_2003 = df_assam_9.loc[df_assam_9['Crop_Year'] == 2003,'Area':'Production']
df_assam_9_2003_sum = df_assam_9_2003.sum(axis = 0, skipna = True) 
print(df_assam_9_2003_sum)
print("---------------------------------")
print("Data for Crop_Year = 2004")
print("---------------------------------")
df_assam_9_2004 = df_assam_9.loc[df_assam_9['Crop_Year'] == 2004,'Area':'Production']
df_assam_9_2004_sum = df_assam_9_2004.sum(axis = 0, skipna = True) 
print(df_assam_9_2004_sum)
print("---------------------------------")
print("Data for Crop_Year = 2005")
print("---------------------------------")
df_assam_9_2005 = df_assam_9.loc[df_assam_9['Crop_Year'] == 2005,'Area':'Production']
df_assam_9_2005_sum = df_assam_9_2005.sum(axis = 0, skipna = True) 
print(df_assam_9_2005_sum)
print("---------------------------------")
print("Data for Crop_Year = 2006")
print("---------------------------------")
df_assam_9_2006 = df_assam_9.loc[df_assam_9['Crop_Year'] == 2006,'Area':'Production'] 
df_assam_9_2006_sum = df_assam_9_2006.sum(axis = 0, skipna = True)
print(df_assam_9_2006_sum)
print("---------------------------------")
print("Data for Crop_Year = 2007")
print("---------------------------------")
df_assam_9_2007 = df_assam_9.loc[df_assam_9['Crop_Year'] == 2007,'Area':'Production']
df_assam_9_2007_sum = df_assam_9_2007.sum(axis = 0, skipna = True) 
print(df_assam_9_2007_sum)
print("---------------------------------")
print("Data for Crop_Year = 2008")
print("---------------------------------")
df_assam_9_2008 = df_assam_9.loc[df_assam_9['Crop_Year'] == 2008,'Area':'Production']
df_assam_9_2008_sum = df_assam_9_2008.sum(axis = 0, skipna = True) 
print(df_assam_9_2008_sum)
print("---------------------------------")
print("Data for Crop_Year = 2009")
print("---------------------------------")
df_assam_9_2009 = df_assam_9.loc[df_assam_9['Crop_Year'] == 2009,'Area':'Production']
df_assam_9_2009_sum = df_assam_9_2009.sum(axis = 0, skipna = True) 
print(df_assam_9_2009_sum)
print("---------------------------------")
print("Data for Crop_Year = 2010")
print("---------------------------------")
df_assam_9_2010 = df_assam_9.loc[df_assam_9['Crop_Year'] == 2010,'Area':'Production'] 
df_assam_9_2010_sum = df_assam_9_2010.sum(axis = 0, skipna = True)
print(df_assam_9_2010_sum)
print("---------------------------------")
print("Data for Crop_Year = 2011")
print("---------------------------------")
df_assam_9_2011 = df_assam_9.loc[df_assam_9['Crop_Year'] == 2011,'Area':'Production'] 
df_assam_9_2011_sum = df_assam_9_2011.sum(axis = 0, skipna = True)
print(df_assam_9_2011_sum)
print("---------------------------------")
print("Data for Crop_Year = 2012")
print("---------------------------------")
df_assam_9_2012 = df_assam_9.loc[df_assam_9['Crop_Year'] == 2012,'Area':'Production']
df_assam_9_2012_sum = df_assam_9_2012.sum(axis = 0, skipna = True) 
print(df_assam_9_2012_sum)
print("---------------------------------")
print("Data for Crop_Year = 2013")
print("---------------------------------")
df_assam_9_2013 = df_assam_9.loc[df_assam_9['Crop_Year'] == 2013,'Area':'Production'] 
df_assam_9_2013_sum = df_assam_9_2013.sum(axis = 0, skipna = True)
print(df_assam_9_2013_sum)
print("---------------------------------")
print("Data for Crop_Year = 2014")
print("---------------------------------")
df_assam_9_2014 = df_assam_9.loc[df_assam_9['Crop_Year'] == 2014,'Area':'Production']
df_assam_9_2014_sum = df_assam_9_2014.sum(axis = 0, skipna = True) 
print(df_assam_9_2014_sum)
print("---------------------------------")
                  
# details of assam : [10] DIMA HASAO

print(" --- Details of assam : [10] DIMA HASAO -----")
df_assam_10 = df_assam[df_assam.District_Name == 'DIMA HASAO']

# Select rows from year =( 1997 to 2014 ) and all columns between 'Area' and 'Production'

print("---------------------------------")
print("Data for Crop_Year = 1997")
print("---------------------------------")
df_assam_10_1997 = df_assam_10.loc[df_assam_10['Crop_Year'] == 1997,'Area':'Production']
df_assam_10_1997_sum = df_assam_10_1997.sum(axis = 0, skipna = True)
print(df_assam_10_1997_sum)
print("---------------------------------")
print("Data for Crop_Year = 1998")
print("---------------------------------")
df_assam_10_1998 = df_assam_10.loc[df_assam_10['Crop_Year'] == 1998,'Area':'Production']
df_assam_10_1998_sum = df_assam_10_1998.sum(axis = 0, skipna = True) 
print(df_assam_10_1998_sum)
print("---------------------------------")
print("Data for Crop_Year = 1999")
print("---------------------------------")
df_assam_10_1999 = df_assam_10.loc[df_assam_10['Crop_Year'] == 1999,'Area':'Production']
df_assam_10_1999_sum = df_assam_10_1999.sum(axis = 0, skipna = True) 
print(df_assam_10_1999_sum)
print("---------------------------------")
print("Data for Crop_Year = 2000")
print("---------------------------------")
df_assam_10_2000 = df_assam_10.loc[df_assam_10['Crop_Year'] == 2000,'Area':'Production']
df_assam_10_2000_sum = df_assam_10_2000.sum(axis = 0, skipna = True) 
print(df_assam_10_2000_sum)
print("---------------------------------")
print("Data for Crop_Year = 2001")
print("---------------------------------")
df_assam_10_2001 = df_assam_10.loc[df_assam_10['Crop_Year'] == 2001,'Area':'Production'] 
df_assam_10_2001_sum = df_assam_10_2001.sum(axis = 0, skipna = True)
print(df_assam_10_2001_sum)
print("---------------------------------")
print("Data for Crop_Year = 2002")
print("---------------------------------")
df_assam_10_2002 = df_assam_10.loc[df_assam_10['Crop_Year'] == 2002,'Area':'Production']
df_assam_10_2002_sum = df_assam_10_2002.sum(axis = 0, skipna = True) 
print(df_assam_10_2002_sum)
print("---------------------------------")
print("Data for Crop_Year = 2003")
print("---------------------------------")
df_assam_10_2003 = df_assam_10.loc[df_assam_10['Crop_Year'] == 2003,'Area':'Production']
df_assam_10_2003_sum = df_assam_10_2003.sum(axis = 0, skipna = True) 
print(df_assam_10_2003_sum)
print("---------------------------------")
print("Data for Crop_Year = 2004")
print("---------------------------------")
df_assam_10_2004 = df_assam_10.loc[df_assam_10['Crop_Year'] == 2004,'Area':'Production']
df_assam_10_2004_sum = df_assam_10_2004.sum(axis = 0, skipna = True) 
print(df_assam_10_2004_sum)
print("---------------------------------")
print("Data for Crop_Year = 2005")
print("---------------------------------")
df_assam_10_2005 = df_assam_10.loc[df_assam_10['Crop_Year'] == 2005,'Area':'Production']
df_assam_10_2005_sum = df_assam_10_2005.sum(axis = 0, skipna = True) 
print(df_assam_10_2005_sum)
print("---------------------------------")
print("Data for Crop_Year = 2006")
print("---------------------------------")
df_assam_10_2006 = df_assam_10.loc[df_assam_10['Crop_Year'] == 2006,'Area':'Production'] 
df_assam_10_2006_sum = df_assam_10_2006.sum(axis = 0, skipna = True)
print(df_assam_10_2006_sum)
print("---------------------------------")
print("Data for Crop_Year = 2007")
print("---------------------------------")
df_assam_10_2007 = df_assam_10.loc[df_assam_10['Crop_Year'] == 2007,'Area':'Production']
df_assam_10_2007_sum = df_assam_10_2007.sum(axis = 0, skipna = True) 
print(df_assam_10_2007_sum)
print("---------------------------------")
print("Data for Crop_Year = 2008")
print("---------------------------------")
df_assam_10_2008 = df_assam_10.loc[df_assam_10['Crop_Year'] == 2008,'Area':'Production']
df_assam_10_2008_sum = df_assam_10_2008.sum(axis = 0, skipna = True) 
print(df_assam_10_2008_sum)
print("---------------------------------")
print("Data for Crop_Year = 2009")
print("---------------------------------")
df_assam_10_2009 = df_assam_10.loc[df_assam_10['Crop_Year'] == 2009,'Area':'Production']
df_assam_10_2009_sum = df_assam_10_2009.sum(axis = 0, skipna = True) 
print(df_assam_10_2009_sum)
print("---------------------------------")
print("Data for Crop_Year = 2010")
print("---------------------------------")
df_assam_10_2010 = df_assam_10.loc[df_assam_10['Crop_Year'] == 2010,'Area':'Production'] 
df_assam_10_2010_sum = df_assam_10_2010.sum(axis = 0, skipna = True)
print(df_assam_10_2010_sum)
print("---------------------------------")
print("Data for Crop_Year = 2011")
print("---------------------------------")
df_assam_10_2011 = df_assam_10.loc[df_assam_10['Crop_Year'] == 2011,'Area':'Production'] 
df_assam_10_2011_sum = df_assam_10_2011.sum(axis = 0, skipna = True)
print(df_assam_10_2011_sum)
print("---------------------------------")
print("Data for Crop_Year = 2012")
print("---------------------------------")
df_assam_10_2012 = df_assam_10.loc[df_assam_10['Crop_Year'] == 2012,'Area':'Production']
df_assam_10_2012_sum = df_assam_10_2012.sum(axis = 0, skipna = True) 
print(df_assam_10_2012_sum)
print("---------------------------------")
print("Data for Crop_Year = 2013")
print("---------------------------------")
df_assam_10_2013 = df_assam_10.loc[df_assam_10['Crop_Year'] == 2013,'Area':'Production'] 
df_assam_10_2013_sum = df_assam_10_2013.sum(axis = 0, skipna = True)
print(df_assam_10_2013_sum)
print("---------------------------------")
print("Data for Crop_Year = 2014")
print("---------------------------------")
df_assam_10_2014 = df_assam_10.loc[df_assam_10['Crop_Year'] == 2014,'Area':'Production']
df_assam_10_2014_sum = df_assam_10_2014.sum(axis = 0, skipna = True) 
print(df_assam_10_2014_sum)
print("---------------------------------")
       
# details of assam : [11] GOALPARA

print("---- Details of assam : [11] GOALPARA -----")
df_assam_11 = df_assam[df_assam.District_Name == 'GOALPARA']

# Select rows from year =( 1997 to 2014 ) and all columns between 'Area' and 'Production'

print("---------------------------------")
print("Data for Crop_Year = 1997")
print("---------------------------------")
df_assam_11_1997 = df_assam_11.loc[df_assam_11['Crop_Year'] == 1997,'Area':'Production']
df_assam_11_1997_sum = df_assam_11_1997.sum(axis = 0, skipna = True)
print(df_assam_11_1997_sum)
print("---------------------------------")
print("Data for Crop_Year = 1998")
print("---------------------------------")
df_assam_11_1998 = df_assam_11.loc[df_assam_11['Crop_Year'] == 1998,'Area':'Production']
df_assam_11_1998_sum = df_assam_11_1998.sum(axis = 0, skipna = True) 
print(df_assam_11_1998_sum)
print("---------------------------------")
print("Data for Crop_Year = 1999")
print("---------------------------------")
df_assam_11_1999 = df_assam_11.loc[df_assam_11['Crop_Year'] == 1999,'Area':'Production']
df_assam_11_1999_sum = df_assam_11_1999.sum(axis = 0, skipna = True) 
print(df_assam_11_1999_sum)
print("---------------------------------")
print("Data for Crop_Year = 2000")
print("---------------------------------")
df_assam_11_2000 = df_assam_11.loc[df_assam_11['Crop_Year'] == 2000,'Area':'Production']
df_assam_11_2000_sum = df_assam_11_2000.sum(axis = 0, skipna = True) 
print(df_assam_11_2000_sum)
print("---------------------------------")
print("Data for Crop_Year = 2001")
print("---------------------------------")
df_assam_11_2001 = df_assam_11.loc[df_assam_11['Crop_Year'] == 2001,'Area':'Production'] 
df_assam_11_2001_sum = df_assam_11_2001.sum(axis = 0, skipna = True)
print(df_assam_11_2001_sum)
print("---------------------------------")
print("Data for Crop_Year = 2002")
print("---------------------------------")
df_assam_11_2002 = df_assam_11.loc[df_assam_11['Crop_Year'] == 2002,'Area':'Production']
df_assam_11_2002_sum = df_assam_11_2002.sum(axis = 0, skipna = True) 
print(df_assam_11_2002_sum)
print("---------------------------------")
print("Data for Crop_Year = 2003")
print("---------------------------------")
df_assam_11_2003 = df_assam_11.loc[df_assam_11['Crop_Year'] == 2003,'Area':'Production']
df_assam_11_2003_sum = df_assam_11_2003.sum(axis = 0, skipna = True) 
print(df_assam_11_2003_sum)
print("---------------------------------")
print("Data for Crop_Year = 2004")
print("---------------------------------")
df_assam_11_2004 = df_assam_11.loc[df_assam_11['Crop_Year'] == 2004,'Area':'Production']
df_assam_11_2004_sum = df_assam_11_2004.sum(axis = 0, skipna = True) 
print(df_assam_11_2004_sum)
print("---------------------------------")
print("Data for Crop_Year = 2005")
print("---------------------------------")
df_assam_11_2005 = df_assam_11.loc[df_assam_11['Crop_Year'] == 2005,'Area':'Production']
df_assam_11_2005_sum = df_assam_11_2005.sum(axis = 0, skipna = True) 
print(df_assam_11_2005_sum)
print("---------------------------------")
print("Data for Crop_Year = 2006")
print("---------------------------------")
df_assam_11_2006 = df_assam_11.loc[df_assam_11['Crop_Year'] == 2006,'Area':'Production'] 
df_assam_11_2006_sum = df_assam_11_2006.sum(axis = 0, skipna = True)
print(df_assam_11_2006_sum)
print("---------------------------------")
print("Data for Crop_Year = 2007")
print("---------------------------------")
df_assam_11_2007 = df_assam_11.loc[df_assam_11['Crop_Year'] == 2007,'Area':'Production']
df_assam_11_2007_sum = df_assam_11_2007.sum(axis = 0, skipna = True) 
print(df_assam_11_2007_sum)
print("---------------------------------")
print("Data for Crop_Year = 2008")
print("---------------------------------")
df_assam_11_2008 = df_assam_11.loc[df_assam_11['Crop_Year'] == 2008,'Area':'Production']
df_assam_11_2008_sum = df_assam_11_2008.sum(axis = 0, skipna = True) 
print(df_assam_11_2008_sum)
print("---------------------------------")
print("Data for Crop_Year = 2009")
print("---------------------------------")
df_assam_11_2009 = df_assam_11.loc[df_assam_11['Crop_Year'] == 2009,'Area':'Production']
df_assam_11_2009_sum = df_assam_11_2009.sum(axis = 0, skipna = True) 
print(df_assam_11_2009_sum)
print("---------------------------------")
print("Data for Crop_Year = 2010")
print("---------------------------------")
df_assam_11_2010 = df_assam_11.loc[df_assam_11['Crop_Year'] == 2010,'Area':'Production'] 
df_assam_11_2010_sum = df_assam_11_2010.sum(axis = 0, skipna = True)
print(df_assam_11_2010_sum)
print("---------------------------------")
print("Data for Crop_Year = 2011")
print("---------------------------------")
df_assam_11_2011 = df_assam_11.loc[df_assam_11['Crop_Year'] == 2011,'Area':'Production'] 
df_assam_11_2011_sum = df_assam_11_2011.sum(axis = 0, skipna = True)
print(df_assam_11_2011_sum)
print("---------------------------------")
print("Data for Crop_Year = 2012")
print("---------------------------------")
df_assam_11_2012 = df_assam_11.loc[df_assam_11['Crop_Year'] == 2012,'Area':'Production']
df_assam_11_2012_sum = df_assam_11_2012.sum(axis = 0, skipna = True) 
print(df_assam_11_2012_sum)
print("---------------------------------")
print("Data for Crop_Year = 2013")
print("---------------------------------")
df_assam_11_2013 = df_assam_11.loc[df_assam_11['Crop_Year'] == 2013,'Area':'Production'] 
df_assam_11_2013_sum = df_assam_11_2013.sum(axis = 0, skipna = True)
print(df_assam_11_2013_sum)
print("---------------------------------")
print("Data for Crop_Year = 2014")
print("---------------------------------")
df_assam_11_2014 = df_assam_11.loc[df_assam_11['Crop_Year'] == 2014,'Area':'Production']
df_assam_11_2014_sum = df_assam_11_2014.sum(axis = 0, skipna = True) 
print(df_assam_11_2014_sum)
print("---------------------------------")
                   
# details of assam : [12] GOLAGHAT

print("---- Details of assam : [12] GOLAGHAT ----")
df_assam_12 = df_assam[df_assam.District_Name == 'GOLAGHAT']

# Select rows from year =( 1997 to 2014 ) and all columns between 'Area' and 'Production'

print("---------------------------------")
print("Data for Crop_Year = 1997")
print("---------------------------------")
df_assam_12_1997 = df_assam_12.loc[df_assam_12['Crop_Year'] == 1997,'Area':'Production']
df_assam_12_1997_sum = df_assam_12_1997.sum(axis = 0, skipna = True)
print(df_assam_12_1997_sum)
print("---------------------------------")
print("Data for Crop_Year = 1998")
print("---------------------------------")
df_assam_12_1998 = df_assam_12.loc[df_assam_12['Crop_Year'] == 1998,'Area':'Production']
df_assam_12_1998_sum = df_assam_12_1998.sum(axis = 0, skipna = True) 
print(df_assam_12_1998_sum)
print("---------------------------------")
print("Data for Crop_Year = 1999")
print("---------------------------------")
df_assam_12_1999 = df_assam_12.loc[df_assam_12['Crop_Year'] == 1999,'Area':'Production']
df_assam_12_1999_sum = df_assam_12_1999.sum(axis = 0, skipna = True) 
print(df_assam_12_1999_sum)
print("---------------------------------")
print("Data for Crop_Year = 2000")
print("---------------------------------")
df_assam_12_2000 = df_assam_12.loc[df_assam_12['Crop_Year'] == 2000,'Area':'Production']
df_assam_12_2000_sum = df_assam_12_2000.sum(axis = 0, skipna = True) 
print(df_assam_12_2000_sum)
print("---------------------------------")
print("Data for Crop_Year = 2001")
print("---------------------------------")
df_assam_12_2001 = df_assam_12.loc[df_assam_12['Crop_Year'] == 2001,'Area':'Production'] 
df_assam_12_2001_sum = df_assam_12_2001.sum(axis = 0, skipna = True)
print(df_assam_12_2001_sum)
print("---------------------------------")
print("Data for Crop_Year = 2002")
print("---------------------------------")
df_assam_12_2002 = df_assam_12.loc[df_assam_12['Crop_Year'] == 2002,'Area':'Production']
df_assam_12_2002_sum = df_assam_12_2002.sum(axis = 0, skipna = True) 
print(df_assam_12_2002_sum)
print("---------------------------------")
print("Data for Crop_Year = 2003")
print("---------------------------------")
df_assam_12_2003 = df_assam_12.loc[df_assam_12['Crop_Year'] == 2003,'Area':'Production']
df_assam_12_2003_sum = df_assam_12_2003.sum(axis = 0, skipna = True) 
print(df_assam_12_2003_sum)
print("---------------------------------")
print("Data for Crop_Year = 2004")
print("---------------------------------")
df_assam_12_2004 = df_assam_12.loc[df_assam_12['Crop_Year'] == 2004,'Area':'Production']
df_assam_12_2004_sum = df_assam_12_2004.sum(axis = 0, skipna = True) 
print(df_assam_12_2004_sum)
print("---------------------------------")
print("Data for Crop_Year = 2005")
print("---------------------------------")
df_assam_12_2005 = df_assam_12.loc[df_assam_12['Crop_Year'] == 2005,'Area':'Production']
df_assam_12_2005_sum = df_assam_12_2005.sum(axis = 0, skipna = True) 
print(df_assam_12_2005_sum)
print("---------------------------------")
print("Data for Crop_Year = 2006")
print("---------------------------------")
df_assam_12_2006 = df_assam_12.loc[df_assam_12['Crop_Year'] == 2006,'Area':'Production'] 
df_assam_12_2006_sum = df_assam_12_2006.sum(axis = 0, skipna = True)
print(df_assam_12_2006_sum)
print("---------------------------------")
print("Data for Crop_Year = 2007")
print("---------------------------------")
df_assam_12_2007 = df_assam_12.loc[df_assam_12['Crop_Year'] == 2007,'Area':'Production']
df_assam_12_2007_sum = df_assam_12_2007.sum(axis = 0, skipna = True) 
print(df_assam_12_2007_sum)
print("---------------------------------")
print("Data for Crop_Year = 2008")
print("---------------------------------")
df_assam_12_2008 = df_assam_12.loc[df_assam_12['Crop_Year'] == 2008,'Area':'Production']
df_assam_12_2008_sum = df_assam_12_2008.sum(axis = 0, skipna = True) 
print(df_assam_12_2008_sum)
print("---------------------------------")
print("Data for Crop_Year = 2009")
print("---------------------------------")
df_assam_12_2009 = df_assam_12.loc[df_assam_12['Crop_Year'] == 2009,'Area':'Production']
df_assam_12_2009_sum = df_assam_12_2009.sum(axis = 0, skipna = True) 
print(df_assam_12_2009_sum)
print("---------------------------------")
print("Data for Crop_Year = 2010")
print("---------------------------------")
df_assam_12_2010 = df_assam_12.loc[df_assam_12['Crop_Year'] == 2010,'Area':'Production'] 
df_assam_12_2010_sum = df_assam_12_2010.sum(axis = 0, skipna = True)
print(df_assam_12_2010_sum)
print("---------------------------------")
print("Data for Crop_Year = 2011")
print("---------------------------------")
df_assam_12_2011 = df_assam_12.loc[df_assam_12['Crop_Year'] == 2011,'Area':'Production'] 
df_assam_12_2011_sum = df_assam_12_2011.sum(axis = 0, skipna = True)
print(df_assam_12_2011_sum)
print("---------------------------------")
print("Data for Crop_Year = 2012")
print("---------------------------------")
df_assam_12_2012 = df_assam_12.loc[df_assam_12['Crop_Year'] == 2012,'Area':'Production']
df_assam_12_2012_sum = df_assam_12_2012.sum(axis = 0, skipna = True) 
print(df_assam_12_2012_sum)
print("---------------------------------")
print("Data for Crop_Year = 2013")
print("---------------------------------")
df_assam_12_2013 = df_assam_12.loc[df_assam_12['Crop_Year'] == 2013,'Area':'Production'] 
df_assam_12_2013_sum = df_assam_12_2013.sum(axis = 0, skipna = True)
print(df_assam_12_2013_sum)
print("---------------------------------")
print("Data for Crop_Year = 2014")
print("---------------------------------")
df_assam_12_2014 = df_assam_12.loc[df_assam_12['Crop_Year'] == 2014,'Area':'Production']
df_assam_12_2014_sum = df_assam_12_2014.sum(axis = 0, skipna = True) 
print(df_assam_12_2014_sum)
print("---------------------------------")
                        
# details of assam : [13] HAILAKANDI 

print("---- Details of assam : [13] HAILAKANDI  --------")
df_assam_13 = df_assam[df_assam.District_Name == 'HAILAKANDI']

# Select rows from year =( 1997 to 2014 ) and all columns between 'Area' and 'Production'

print("---------------------------------")
print("Data for Crop_Year = 1997")
print("---------------------------------")
df_assam_13_1997 = df_assam_13.loc[df_assam_13['Crop_Year'] == 1997,'Area':'Production']
df_assam_13_1997_sum = df_assam_13_1997.sum(axis = 0, skipna = True)
print(df_assam_13_1997_sum)
print("---------------------------------")
print("Data for Crop_Year = 1998")
print("---------------------------------")
df_assam_13_1998 = df_assam_13.loc[df_assam_13['Crop_Year'] == 1998,'Area':'Production']
df_assam_13_1998_sum = df_assam_13_1998.sum(axis = 0, skipna = True) 
print(df_assam_13_1998_sum)
print("---------------------------------")
print("Data for Crop_Year = 1999")
print("---------------------------------")
df_assam_13_1999 = df_assam_13.loc[df_assam_13['Crop_Year'] == 1999,'Area':'Production']
df_assam_13_1999_sum = df_assam_13_1999.sum(axis = 0, skipna = True) 
print(df_assam_13_1999_sum)
print("---------------------------------")
print("Data for Crop_Year = 2000")
print("---------------------------------")
df_assam_13_2000 = df_assam_13.loc[df_assam_13['Crop_Year'] == 2000,'Area':'Production']
df_assam_13_2000_sum = df_assam_13_2000.sum(axis = 0, skipna = True) 
print(df_assam_13_2000_sum)
print("---------------------------------")
print("Data for Crop_Year = 2001")
print("---------------------------------")
df_assam_13_2001 = df_assam_13.loc[df_assam_13['Crop_Year'] == 2001,'Area':'Production'] 
df_assam_13_2001_sum = df_assam_13_2001.sum(axis = 0, skipna = True)
print(df_assam_13_2001_sum)
print("---------------------------------")
print("Data for Crop_Year = 2002")
print("---------------------------------")
df_assam_13_2002 = df_assam_13.loc[df_assam_13['Crop_Year'] == 2002,'Area':'Production']
df_assam_13_2002_sum = df_assam_13_2002.sum(axis = 0, skipna = True) 
print(df_assam_13_2002_sum)
print("---------------------------------")
print("Data for Crop_Year = 2003")
print("---------------------------------")
df_assam_13_2003 = df_assam_13.loc[df_assam_13['Crop_Year'] == 2003,'Area':'Production']
df_assam_13_2003_sum = df_assam_13_2003.sum(axis = 0, skipna = True) 
print(df_assam_13_2003_sum)
print("---------------------------------")
print("Data for Crop_Year = 2004")
print("---------------------------------")
df_assam_13_2004 = df_assam_13.loc[df_assam_13['Crop_Year'] == 2004,'Area':'Production']
df_assam_13_2004_sum = df_assam_13_2004.sum(axis = 0, skipna = True) 
print(df_assam_13_2004_sum)
print("---------------------------------")
print("Data for Crop_Year = 2005")
print("---------------------------------")
df_assam_13_2005 = df_assam_13.loc[df_assam_13['Crop_Year'] == 2005,'Area':'Production']
df_assam_13_2005_sum = df_assam_13_2005.sum(axis = 0, skipna = True) 
print(df_assam_13_2005_sum)
print("---------------------------------")
print("Data for Crop_Year = 2006")
print("---------------------------------")
df_assam_13_2006 = df_assam_13.loc[df_assam_13['Crop_Year'] == 2006,'Area':'Production'] 
df_assam_13_2006_sum = df_assam_13_2006.sum(axis = 0, skipna = True)
print(df_assam_13_2006_sum)
print("---------------------------------")
print("Data for Crop_Year = 2007")
print("---------------------------------")
df_assam_13_2007 = df_assam_13.loc[df_assam_13['Crop_Year'] == 2007,'Area':'Production']
df_assam_13_2007_sum = df_assam_13_2007.sum(axis = 0, skipna = True) 
print(df_assam_13_2007_sum)
print("---------------------------------")
print("Data for Crop_Year = 2008")
print("---------------------------------")
df_assam_13_2008 = df_assam_13.loc[df_assam_13['Crop_Year'] == 2008,'Area':'Production']
df_assam_13_2008_sum = df_assam_13_2008.sum(axis = 0, skipna = True) 
print(df_assam_13_2008_sum)
print("---------------------------------")
print("Data for Crop_Year = 2009")
print("---------------------------------")
df_assam_13_2009 = df_assam_13.loc[df_assam_13['Crop_Year'] == 2009,'Area':'Production']
df_assam_13_2009_sum = df_assam_13_2009.sum(axis = 0, skipna = True) 
print(df_assam_13_2009_sum)
print("---------------------------------")
print("Data for Crop_Year = 2010")
print("---------------------------------")
df_assam_13_2010 = df_assam_13.loc[df_assam_13['Crop_Year'] == 2010,'Area':'Production'] 
df_assam_13_2010_sum = df_assam_13_2010.sum(axis = 0, skipna = True)
print(df_assam_13_2010_sum)
print("---------------------------------")
print("Data for Crop_Year = 2011")
print("---------------------------------")
df_assam_13_2011 = df_assam_13.loc[df_assam_13['Crop_Year'] == 2011,'Area':'Production'] 
df_assam_13_2011_sum = df_assam_13_2011.sum(axis = 0, skipna = True)
print(df_assam_13_2011_sum)
print("---------------------------------")
print("Data for Crop_Year = 2012")
print("---------------------------------")
df_assam_13_2012 = df_assam_13.loc[df_assam_13['Crop_Year'] == 2012,'Area':'Production']
df_assam_13_2012_sum = df_assam_13_2012.sum(axis = 0, skipna = True) 
print(df_assam_13_2012_sum)
print("---------------------------------")
print("Data for Crop_Year = 2013")
print("---------------------------------")
df_assam_13_2013 = df_assam_13.loc[df_assam_13['Crop_Year'] == 2013,'Area':'Production'] 
df_assam_13_2013_sum = df_assam_13_2013.sum(axis = 0, skipna = True)
print(df_assam_13_2013_sum)
print("---------------------------------")
print("Data for Crop_Year = 2014")
print("---------------------------------")
df_assam_13_2014 = df_assam_13.loc[df_assam_13['Crop_Year'] == 2014,'Area':'Production']
df_assam_13_2014_sum = df_assam_13_2014.sum(axis = 0, skipna = True) 
print(df_assam_13_2014_sum)
print("---------------------------------")

# details of assam : [14] JORHAT

print("---- Details of assam : [14] JORHAT --------")
df_assam_14 = df_assam[df_assam.District_Name == 'JORHAT']

# Select rows from year =( 1997 to 2014 ) and all columns between 'Area' and 'Production'

print("---------------------------------")
print("Data for Crop_Year = 1997")
print("---------------------------------")
df_assam_14_1997 = df_assam_14.loc[df_assam_14['Crop_Year'] == 1997,'Area':'Production']
df_assam_14_1997_sum = df_assam_14_1997.sum(axis = 0, skipna = True)
print(df_assam_14_1997_sum)
print("---------------------------------")
print("Data for Crop_Year = 1998")
print("---------------------------------")
df_assam_14_1998 = df_assam_14.loc[df_assam_14['Crop_Year'] == 1998,'Area':'Production']
df_assam_14_1998_sum = df_assam_14_1998.sum(axis = 0, skipna = True) 
print(df_assam_14_1998_sum)
print("---------------------------------")
print("Data for Crop_Year = 1999")
print("---------------------------------")
df_assam_14_1999 = df_assam_14.loc[df_assam_14['Crop_Year'] == 1999,'Area':'Production']
df_assam_14_1999_sum = df_assam_14_1999.sum(axis = 0, skipna = True) 
print(df_assam_14_1999_sum)
print("---------------------------------")
print("Data for Crop_Year = 2000")
print("---------------------------------")
df_assam_14_2000 = df_assam_14.loc[df_assam_14['Crop_Year'] == 2000,'Area':'Production']
df_assam_14_2000_sum = df_assam_14_2000.sum(axis = 0, skipna = True) 
print(df_assam_14_2000_sum)
print("---------------------------------")
print("Data for Crop_Year = 2001")
print("---------------------------------")
df_assam_14_2001 = df_assam_14.loc[df_assam_14['Crop_Year'] == 2001,'Area':'Production'] 
df_assam_14_2001_sum = df_assam_14_2001.sum(axis = 0, skipna = True)
print(df_assam_14_2001_sum)
print("---------------------------------")
print("Data for Crop_Year = 2002")
print("---------------------------------")
df_assam_14_2002 = df_assam_14.loc[df_assam_14['Crop_Year'] == 2002,'Area':'Production']
df_assam_14_2002_sum = df_assam_14_2002.sum(axis = 0, skipna = True) 
print(df_assam_14_2002_sum)
print("---------------------------------")
print("Data for Crop_Year = 2003")
print("---------------------------------")
df_assam_14_2003 = df_assam_14.loc[df_assam_14['Crop_Year'] == 2003,'Area':'Production']
df_assam_14_2003_sum = df_assam_14_2003.sum(axis = 0, skipna = True) 
print(df_assam_14_2003_sum)
print("---------------------------------")
print("Data for Crop_Year = 2004")
print("---------------------------------")
df_assam_14_2004 = df_assam_14.loc[df_assam_14['Crop_Year'] == 2004,'Area':'Production']
df_assam_14_2004_sum = df_assam_14_2004.sum(axis = 0, skipna = True) 
print(df_assam_14_2004_sum)
print("---------------------------------")
print("Data for Crop_Year = 2005")
print("---------------------------------")
df_assam_14_2005 = df_assam_14.loc[df_assam_14['Crop_Year'] == 2005,'Area':'Production']
df_assam_14_2005_sum = df_assam_14_2005.sum(axis = 0, skipna = True) 
print(df_assam_14_2005_sum)
print("---------------------------------")
print("Data for Crop_Year = 2006")
print("---------------------------------")
df_assam_14_2006 = df_assam_14.loc[df_assam_14['Crop_Year'] == 2006,'Area':'Production'] 
df_assam_14_2006_sum = df_assam_14_2006.sum(axis = 0, skipna = True)
print(df_assam_14_2006_sum)
print("---------------------------------")
print("Data for Crop_Year = 2007")
print("---------------------------------")
df_assam_14_2007 = df_assam_14.loc[df_assam_14['Crop_Year'] == 2007,'Area':'Production']
df_assam_14_2007_sum = df_assam_14_2007.sum(axis = 0, skipna = True) 
print(df_assam_14_2007_sum)
print("---------------------------------")
print("Data for Crop_Year = 2008")
print("---------------------------------")
df_assam_14_2008 = df_assam_14.loc[df_assam_14['Crop_Year'] == 2008,'Area':'Production']
df_assam_14_2008_sum = df_assam_14_2008.sum(axis = 0, skipna = True) 
print(df_assam_14_2008_sum)
print("---------------------------------")
print("Data for Crop_Year = 2009")
print("---------------------------------")
df_assam_14_2009 = df_assam_14.loc[df_assam_14['Crop_Year'] == 2009,'Area':'Production']
df_assam_14_2009_sum = df_assam_14_2009.sum(axis = 0, skipna = True) 
print(df_assam_14_2009_sum)
print("---------------------------------")
print("Data for Crop_Year = 2010")
print("---------------------------------")
df_assam_14_2010 = df_assam_14.loc[df_assam_14['Crop_Year'] == 2010,'Area':'Production'] 
df_assam_14_2010_sum = df_assam_14_2010.sum(axis = 0, skipna = True)
print(df_assam_14_2010_sum)
print("---------------------------------")
print("Data for Crop_Year = 2011")
print("---------------------------------")
df_assam_14_2011 = df_assam_14.loc[df_assam_14['Crop_Year'] == 2011,'Area':'Production'] 
df_assam_14_2011_sum = df_assam_14_2011.sum(axis = 0, skipna = True)
print(df_assam_14_2011_sum)
print("---------------------------------")
print("Data for Crop_Year = 2012")
print("---------------------------------")
df_assam_14_2012 = df_assam_14.loc[df_assam_14['Crop_Year'] == 2012,'Area':'Production']
df_assam_14_2012_sum = df_assam_14_2012.sum(axis = 0, skipna = True) 
print(df_assam_14_2012_sum)
print("---------------------------------")
print("Data for Crop_Year = 2013")
print("---------------------------------")
df_assam_14_2013 = df_assam_14.loc[df_assam_14['Crop_Year'] == 2013,'Area':'Production'] 
df_assam_14_2013_sum = df_assam_14_2013.sum(axis = 0, skipna = True)
print(df_assam_14_2013_sum)
print("---------------------------------")
print("Data for Crop_Year = 2014")
print("---------------------------------")
df_assam_14_2014 = df_assam_14.loc[df_assam_14['Crop_Year'] == 2014,'Area':'Production']
df_assam_14_2014_sum = df_assam_14_2014.sum(axis = 0, skipna = True) 
print(df_assam_14_2014_sum)
print("---------------------------------")
                                    
# details of assam : [15] KAMRUP

print("---- Details of assam : [15] KAMRUP -----")
df_assam_15 = df_assam[df_assam.District_Name == 'KAMRUP']

# Select rows from year =( 1997 to 2014 ) and all columns between 'Area' and 'Production'

print("---------------------------------")
print("Data for Crop_Year = 1997")
print("---------------------------------")
df_assam_15_1997 = df_assam_15.loc[df_assam_15['Crop_Year'] == 1997,'Area':'Production']
df_assam_15_1997_sum = df_assam_15_1997.sum(axis = 0, skipna = True)
print(df_assam_15_1997_sum)
print("---------------------------------")
print("Data for Crop_Year = 1998")
print("---------------------------------")
df_assam_15_1998 = df_assam_15.loc[df_assam_15['Crop_Year'] == 1998,'Area':'Production']
df_assam_15_1998_sum = df_assam_15_1998.sum(axis = 0, skipna = True) 
print(df_assam_15_1998_sum)
print("---------------------------------")
print("Data for Crop_Year = 1999")
print("---------------------------------")
df_assam_15_1999 = df_assam_15.loc[df_assam_15['Crop_Year'] == 1999,'Area':'Production']
df_assam_15_1999_sum = df_assam_15_1999.sum(axis = 0, skipna = True) 
print(df_assam_15_1999_sum)
print("---------------------------------")
print("Data for Crop_Year = 2000")
print("---------------------------------")
df_assam_15_2000 = df_assam_15.loc[df_assam_15['Crop_Year'] == 2000,'Area':'Production']
df_assam_15_2000_sum = df_assam_15_2000.sum(axis = 0, skipna = True) 
print(df_assam_15_2000_sum)
print("---------------------------------")
print("Data for Crop_Year = 2001")
print("---------------------------------")
df_assam_15_2001 = df_assam_15.loc[df_assam_15['Crop_Year'] == 2001,'Area':'Production'] 
df_assam_15_2001_sum = df_assam_15_2001.sum(axis = 0, skipna = True)
print(df_assam_15_2001_sum)
print("---------------------------------")
print("Data for Crop_Year = 2002")
print("---------------------------------")
df_assam_15_2002 = df_assam_15.loc[df_assam_15['Crop_Year'] == 2002,'Area':'Production']
df_assam_15_2002_sum = df_assam_15_2002.sum(axis = 0, skipna = True) 
print(df_assam_15_2002_sum)
print("---------------------------------")
print("Data for Crop_Year = 2003")
print("---------------------------------")
df_assam_15_2003 = df_assam_15.loc[df_assam_15['Crop_Year'] == 2003,'Area':'Production']
df_assam_15_2003_sum = df_assam_15_2003.sum(axis = 0, skipna = True) 
print(df_assam_15_2003_sum)
print("---------------------------------")
print("Data for Crop_Year = 2004")
print("---------------------------------")
df_assam_15_2004 = df_assam_15.loc[df_assam_15['Crop_Year'] == 2004,'Area':'Production']
df_assam_15_2004_sum = df_assam_15_2004.sum(axis = 0, skipna = True) 
print(df_assam_15_2004_sum)
print("---------------------------------")
print("Data for Crop_Year = 2005")
print("---------------------------------")
df_assam_15_2005 = df_assam_15.loc[df_assam_15['Crop_Year'] == 2005,'Area':'Production']
df_assam_15_2005_sum = df_assam_15_2005.sum(axis = 0, skipna = True) 
print(df_assam_15_2005_sum)
print("---------------------------------")
print("Data for Crop_Year = 2006")
print("---------------------------------")
df_assam_15_2006 = df_assam_15.loc[df_assam_15['Crop_Year'] == 2006,'Area':'Production'] 
df_assam_15_2006_sum = df_assam_15_2006.sum(axis = 0, skipna = True)
print(df_assam_15_2006_sum)
print("---------------------------------")
print("Data for Crop_Year = 2007")
print("---------------------------------")
df_assam_15_2007 = df_assam_15.loc[df_assam_15['Crop_Year'] == 2007,'Area':'Production']
df_assam_15_2007_sum = df_assam_15_2007.sum(axis = 0, skipna = True) 
print(df_assam_15_2007_sum)
print("---------------------------------")
print("Data for Crop_Year = 2008")
print("---------------------------------")
df_assam_15_2008 = df_assam_15.loc[df_assam_15['Crop_Year'] == 2008,'Area':'Production']
df_assam_15_2008_sum = df_assam_15_2008.sum(axis = 0, skipna = True) 
print(df_assam_15_2008_sum)
print("---------------------------------")
print("Data for Crop_Year = 2009")
print("---------------------------------")
df_assam_15_2009 = df_assam_15.loc[df_assam_15['Crop_Year'] == 2009,'Area':'Production']
df_assam_15_2009_sum = df_assam_15_2009.sum(axis = 0, skipna = True) 
print(df_assam_15_2009_sum)
print("---------------------------------")
print("Data for Crop_Year = 2010")
print("---------------------------------")
df_assam_15_2010 = df_assam_15.loc[df_assam_15['Crop_Year'] == 2010,'Area':'Production'] 
df_assam_15_2010_sum = df_assam_15_2010.sum(axis = 0, skipna = True)
print(df_assam_15_2010_sum)
print("---------------------------------")
print("Data for Crop_Year = 2011")
print("---------------------------------")
df_assam_15_2011 = df_assam_15.loc[df_assam_15['Crop_Year'] == 2011,'Area':'Production'] 
df_assam_15_2011_sum = df_assam_15_2011.sum(axis = 0, skipna = True)
print(df_assam_15_2011_sum)
print("---------------------------------")
print("Data for Crop_Year = 2012")
print("---------------------------------")
df_assam_15_2012 = df_assam_15.loc[df_assam_15['Crop_Year'] == 2012,'Area':'Production']
df_assam_15_2012_sum = df_assam_15_2012.sum(axis = 0, skipna = True) 
print(df_assam_15_2012_sum)
print("---------------------------------")
print("Data for Crop_Year = 2013")
print("---------------------------------")
df_assam_15_2013 = df_assam_15.loc[df_assam_15['Crop_Year'] == 2013,'Area':'Production'] 
df_assam_15_2013_sum = df_assam_15_2013.sum(axis = 0, skipna = True)
print(df_assam_15_2013_sum)
print("---------------------------------")
print("Data for Crop_Year = 2014")
print("---------------------------------")
df_assam_15_2014 = df_assam_15.loc[df_assam_15['Crop_Year'] == 2014,'Area':'Production']
df_assam_15_2014_sum = df_assam_15_2014.sum(axis = 0, skipna = True) 
print(df_assam_15_2014_sum)
print("---------------------------------")
                               
# details of assam : [16] KAMRUP METRO 

print("----- Details of assam : [16] KAMRUP METRO ----")
df_assam_16 = df_assam[df_assam.District_Name == 'KAMRUP METRO']

# Select rows from year =( 1997 to 2014 ) and all columns between 'Area' and 'Production'

print("---------------------------------")
print("Data for Crop_Year = 1997")
print("---------------------------------")
df_assam_16_1997 = df_assam_16.loc[df_assam_16['Crop_Year'] == 1997,'Area':'Production']
df_assam_16_1997_sum = df_assam_16_1997.sum(axis = 0, skipna = True)
print(df_assam_16_1997_sum)
print("---------------------------------")
print("Data for Crop_Year = 1998")
print("---------------------------------")
df_assam_16_1998 = df_assam_16.loc[df_assam_16['Crop_Year'] == 1998,'Area':'Production']
df_assam_16_1998_sum = df_assam_16_1998.sum(axis = 0, skipna = True) 
print(df_assam_16_1998_sum)
print("---------------------------------")
print("Data for Crop_Year = 1999")
print("---------------------------------")
df_assam_16_1999 = df_assam_16.loc[df_assam_16['Crop_Year'] == 1999,'Area':'Production']
df_assam_16_1999_sum = df_assam_16_1999.sum(axis = 0, skipna = True) 
print(df_assam_16_1999_sum)
print("---------------------------------")
print("Data for Crop_Year = 2000")
print("---------------------------------")
df_assam_16_2000 = df_assam_16.loc[df_assam_16['Crop_Year'] == 2000,'Area':'Production']
df_assam_16_2000_sum = df_assam_16_2000.sum(axis = 0, skipna = True) 
print(df_assam_16_2000_sum)
print("---------------------------------")
print("Data for Crop_Year = 2001")
print("---------------------------------")
df_assam_16_2001 = df_assam_16.loc[df_assam_16['Crop_Year'] == 2001,'Area':'Production'] 
df_assam_16_2001_sum = df_assam_16_2001.sum(axis = 0, skipna = True)
print(df_assam_16_2001_sum)
print("---------------------------------")
print("Data for Crop_Year = 2002")
print("---------------------------------")
df_assam_16_2002 = df_assam_16.loc[df_assam_16['Crop_Year'] == 2002,'Area':'Production']
df_assam_16_2002_sum = df_assam_16_2002.sum(axis = 0, skipna = True) 
print(df_assam_16_2002_sum)
print("---------------------------------")
print("Data for Crop_Year = 2003")
print("---------------------------------")
df_assam_16_2003 = df_assam_16.loc[df_assam_16['Crop_Year'] == 2003,'Area':'Production']
df_assam_16_2003_sum = df_assam_16_2003.sum(axis = 0, skipna = True) 
print(df_assam_16_2003_sum)
print("---------------------------------")
print("Data for Crop_Year = 2004")
print("---------------------------------")
df_assam_16_2004 = df_assam_16.loc[df_assam_16['Crop_Year'] == 2004,'Area':'Production']
df_assam_16_2004_sum = df_assam_16_2004.sum(axis = 0, skipna = True) 
print(df_assam_16_2004_sum)
print("---------------------------------")
print("Data for Crop_Year = 2005")
print("---------------------------------")
df_assam_16_2005 = df_assam_16.loc[df_assam_16['Crop_Year'] == 2005,'Area':'Production']
df_assam_16_2005_sum = df_assam_16_2005.sum(axis = 0, skipna = True) 
print(df_assam_16_2005_sum)
print("---------------------------------")
print("Data for Crop_Year = 2006")
print("---------------------------------")
df_assam_16_2006 = df_assam_16.loc[df_assam_16['Crop_Year'] == 2006,'Area':'Production'] 
df_assam_16_2006_sum = df_assam_16_2006.sum(axis = 0, skipna = True)
print(df_assam_16_2006_sum)
print("---------------------------------")
print("Data for Crop_Year = 2007")
print("---------------------------------")
df_assam_16_2007 = df_assam_16.loc[df_assam_16['Crop_Year'] == 2007,'Area':'Production']
df_assam_16_2007_sum = df_assam_16_2007.sum(axis = 0, skipna = True) 
print(df_assam_16_2007_sum)
print("---------------------------------")
print("Data for Crop_Year = 2008")
print("---------------------------------")
df_assam_16_2008 = df_assam_16.loc[df_assam_16['Crop_Year'] == 2008,'Area':'Production']
df_assam_16_2008_sum = df_assam_16_2008.sum(axis = 0, skipna = True) 
print(df_assam_16_2008_sum)
print("---------------------------------")
print("Data for Crop_Year = 2009")
print("---------------------------------")
df_assam_16_2009 = df_assam_16.loc[df_assam_16['Crop_Year'] == 2009,'Area':'Production']
df_assam_16_2009_sum = df_assam_16_2009.sum(axis = 0, skipna = True) 
print(df_assam_16_2009_sum)
print("---------------------------------")
print("Data for Crop_Year = 2010")
print("---------------------------------")
df_assam_16_2010 = df_assam_16.loc[df_assam_16['Crop_Year'] == 2010,'Area':'Production'] 
df_assam_16_2010_sum = df_assam_16_2010.sum(axis = 0, skipna = True)
print(df_assam_16_2010_sum)
print("---------------------------------")
print("Data for Crop_Year = 2011")
print("---------------------------------")
df_assam_16_2011 = df_assam_16.loc[df_assam_16['Crop_Year'] == 2011,'Area':'Production'] 
df_assam_16_2011_sum = df_assam_16_2011.sum(axis = 0, skipna = True)
print(df_assam_16_2011_sum)
print("---------------------------------")
print("Data for Crop_Year = 2012")
print("---------------------------------")
df_assam_16_2012 = df_assam_16.loc[df_assam_16['Crop_Year'] == 2012,'Area':'Production']
df_assam_16_2012_sum = df_assam_16_2012.sum(axis = 0, skipna = True) 
print(df_assam_16_2012_sum)
print("---------------------------------")
print("Data for Crop_Year = 2013")
print("---------------------------------")
df_assam_16_2013 = df_assam_16.loc[df_assam_16['Crop_Year'] == 2013,'Area':'Production'] 
df_assam_16_2013_sum = df_assam_16_2013.sum(axis = 0, skipna = True)
print(df_assam_16_2013_sum)
print("---------------------------------")
print("Data for Crop_Year = 2014")
print("---------------------------------")
df_assam_16_2014 = df_assam_16.loc[df_assam_16['Crop_Year'] == 2014,'Area':'Production']
df_assam_16_2014_sum = df_assam_16_2014.sum(axis = 0, skipna = True) 
print(df_assam_16_2014_sum)
print("---------------------------------")
   
# details of assam : [17] KARBI ANGLONG

print("---- Details of assam : [17] KARBI ANGLONG -----")
df_assam_17 = df_assam[df_assam.District_Name == 'KARBI ANGLONG']

# Select rows from year =( 1997 to 2014 ) and all columns between 'Area' and 'Production'

print("---------------------------------")
print("Data for Crop_Year = 1997")
print("---------------------------------")
df_assam_17_1997 = df_assam_17.loc[df_assam_17['Crop_Year'] == 1997,'Area':'Production']
df_assam_17_1997_sum = df_assam_17_1997.sum(axis = 0, skipna = True)
print(df_assam_17_1997_sum)
print("---------------------------------")
print("Data for Crop_Year = 1998")
print("---------------------------------")
df_assam_17_1998 = df_assam_17.loc[df_assam_17['Crop_Year'] == 1998,'Area':'Production']
df_assam_17_1998_sum = df_assam_17_1998.sum(axis = 0, skipna = True) 
print(df_assam_17_1998_sum)
print("---------------------------------")
print("Data for Crop_Year = 1999")
print("---------------------------------")
df_assam_17_1999 = df_assam_17.loc[df_assam_17['Crop_Year'] == 1999,'Area':'Production']
df_assam_17_1999_sum = df_assam_17_1999.sum(axis = 0, skipna = True) 
print(df_assam_17_1999_sum)
print("---------------------------------")
print("Data for Crop_Year = 2000")
print("---------------------------------")
df_assam_17_2000 = df_assam_17.loc[df_assam_17['Crop_Year'] == 2000,'Area':'Production']
df_assam_17_2000_sum = df_assam_17_2000.sum(axis = 0, skipna = True) 
print(df_assam_17_2000_sum)
print("---------------------------------")
print("Data for Crop_Year = 2001")
print("---------------------------------")
df_assam_17_2001 = df_assam_17.loc[df_assam_17['Crop_Year'] == 2001,'Area':'Production'] 
df_assam_17_2001_sum = df_assam_17_2001.sum(axis = 0, skipna = True)
print(df_assam_17_2001_sum)
print("---------------------------------")
print("Data for Crop_Year = 2002")
print("---------------------------------")
df_assam_17_2002 = df_assam_17.loc[df_assam_17['Crop_Year'] == 2002,'Area':'Production']
df_assam_17_2002_sum = df_assam_17_2002.sum(axis = 0, skipna = True) 
print(df_assam_17_2002_sum)
print("---------------------------------")
print("Data for Crop_Year = 2003")
print("---------------------------------")
df_assam_17_2003 = df_assam_17.loc[df_assam_17['Crop_Year'] == 2003,'Area':'Production']
df_assam_17_2003_sum = df_assam_17_2003.sum(axis = 0, skipna = True) 
print(df_assam_17_2003_sum)
print("---------------------------------")
print("Data for Crop_Year = 2004")
print("---------------------------------")
df_assam_17_2004 = df_assam_17.loc[df_assam_17['Crop_Year'] == 2004,'Area':'Production']
df_assam_17_2004_sum = df_assam_17_2004.sum(axis = 0, skipna = True) 
print(df_assam_17_2004_sum)
print("---------------------------------")
print("Data for Crop_Year = 2005")
print("---------------------------------")
df_assam_17_2005 = df_assam_17.loc[df_assam_17['Crop_Year'] == 2005,'Area':'Production']
df_assam_17_2005_sum = df_assam_17_2005.sum(axis = 0, skipna = True) 
print(df_assam_17_2005_sum)
print("---------------------------------")
print("Data for Crop_Year = 2006")
print("---------------------------------")
df_assam_17_2006 = df_assam_17.loc[df_assam_17['Crop_Year'] == 2006,'Area':'Production'] 
df_assam_17_2006_sum = df_assam_17_2006.sum(axis = 0, skipna = True)
print(df_assam_17_2006_sum)
print("---------------------------------")
print("Data for Crop_Year = 2007")
print("---------------------------------")
df_assam_17_2007 = df_assam_17.loc[df_assam_17['Crop_Year'] == 2007,'Area':'Production']
df_assam_17_2007_sum = df_assam_17_2007.sum(axis = 0, skipna = True) 
print(df_assam_17_2007_sum)
print("---------------------------------")
print("Data for Crop_Year = 2008")
print("---------------------------------")
df_assam_17_2008 = df_assam_17.loc[df_assam_17['Crop_Year'] == 2008,'Area':'Production']
df_assam_17_2008_sum = df_assam_17_2008.sum(axis = 0, skipna = True) 
print(df_assam_17_2008_sum)
print("---------------------------------")
print("Data for Crop_Year = 2009")
print("---------------------------------")
df_assam_17_2009 = df_assam_17.loc[df_assam_17['Crop_Year'] == 2009,'Area':'Production']
df_assam_17_2009_sum = df_assam_17_2009.sum(axis = 0, skipna = True) 
print(df_assam_17_2009_sum)
print("---------------------------------")
print("Data for Crop_Year = 2010")
print("---------------------------------")
df_assam_17_2010 = df_assam_17.loc[df_assam_17['Crop_Year'] == 2010,'Area':'Production'] 
df_assam_17_2010_sum = df_assam_17_2010.sum(axis = 0, skipna = True)
print(df_assam_17_2010_sum)
print("---------------------------------")
print("Data for Crop_Year = 2011")
print("---------------------------------")
df_assam_17_2011 = df_assam_17.loc[df_assam_17['Crop_Year'] == 2011,'Area':'Production'] 
df_assam_17_2011_sum = df_assam_17_2011.sum(axis = 0, skipna = True)
print(df_assam_17_2011_sum)
print("---------------------------------")
print("Data for Crop_Year = 2012")
print("---------------------------------")
df_assam_17_2012 = df_assam_17.loc[df_assam_17['Crop_Year'] == 2012,'Area':'Production']
df_assam_17_2012_sum = df_assam_17_2012.sum(axis = 0, skipna = True) 
print(df_assam_17_2012_sum)
print("---------------------------------")
print("Data for Crop_Year = 2013")
print("---------------------------------")
df_assam_17_2013 = df_assam_17.loc[df_assam_17['Crop_Year'] == 2013,'Area':'Production'] 
df_assam_17_2013_sum = df_assam_17_2013.sum(axis = 0, skipna = True)
print(df_assam_17_2013_sum)
print("---------------------------------")
print("Data for Crop_Year = 2014")
print("---------------------------------")
df_assam_17_2014 = df_assam_17.loc[df_assam_17['Crop_Year'] == 2014,'Area':'Production']
df_assam_17_2014_sum = df_assam_17_2014.sum(axis = 0, skipna = True) 
print(df_assam_17_2014_sum)
print("---------------------------------")
         
# details of assam : [18] KARIMGANJ 

print("---- Details of assam : [18] KARIMGANJ -----")
df_assam_18 = df_assam[df_assam.District_Name == 'KARIMGANJ']

# Select rows from year =( 1997 to 2014 ) and all columns between 'Area' and 'Production'

print("---------------------------------")
print("Data for Crop_Year = 1997")
print("---------------------------------")
df_assam_18_1997 = df_assam_18.loc[df_assam_18['Crop_Year'] == 1997,'Area':'Production']
df_assam_18_1997_sum = df_assam_18_1997.sum(axis = 0, skipna = True)
print(df_assam_18_1997_sum)
print("---------------------------------")
print("Data for Crop_Year = 1998")
print("---------------------------------")
df_assam_18_1998 = df_assam_18.loc[df_assam_18['Crop_Year'] == 1998,'Area':'Production']
df_assam_18_1998_sum = df_assam_18_1998.sum(axis = 0, skipna = True) 
print(df_assam_18_1998_sum)
print("---------------------------------")
print("Data for Crop_Year = 1999")
print("---------------------------------")
df_assam_18_1999 = df_assam_18.loc[df_assam_18['Crop_Year'] == 1999,'Area':'Production']
df_assam_18_1999_sum = df_assam_18_1999.sum(axis = 0, skipna = True) 
print(df_assam_18_1999_sum)
print("---------------------------------")
print("Data for Crop_Year = 2000")
print("---------------------------------")
df_assam_18_2000 = df_assam_18.loc[df_assam_18['Crop_Year'] == 2000,'Area':'Production']
df_assam_18_2000_sum = df_assam_18_2000.sum(axis = 0, skipna = True) 
print(df_assam_18_2000_sum)
print("---------------------------------")
print("Data for Crop_Year = 2001")
print("---------------------------------")
df_assam_18_2001 = df_assam_18.loc[df_assam_18['Crop_Year'] == 2001,'Area':'Production'] 
df_assam_18_2001_sum = df_assam_18_2001.sum(axis = 0, skipna = True)
print(df_assam_18_2001_sum)
print("---------------------------------")
print("Data for Crop_Year = 2002")
print("---------------------------------")
df_assam_18_2002 = df_assam_18.loc[df_assam_18['Crop_Year'] == 2002,'Area':'Production']
df_assam_18_2002_sum = df_assam_18_2002.sum(axis = 0, skipna = True) 
print(df_assam_18_2002_sum)
print("---------------------------------")
print("Data for Crop_Year = 2003")
print("---------------------------------")
df_assam_18_2003 = df_assam_18.loc[df_assam_18['Crop_Year'] == 2003,'Area':'Production']
df_assam_18_2003_sum = df_assam_18_2003.sum(axis = 0, skipna = True) 
print(df_assam_18_2003_sum)
print("---------------------------------")
print("Data for Crop_Year = 2004")
print("---------------------------------")
df_assam_18_2004 = df_assam_18.loc[df_assam_18['Crop_Year'] == 2004,'Area':'Production']
df_assam_18_2004_sum = df_assam_18_2004.sum(axis = 0, skipna = True) 
print(df_assam_18_2004_sum)
print("---------------------------------")
print("Data for Crop_Year = 2005")
print("---------------------------------")
df_assam_18_2005 = df_assam_18.loc[df_assam_18['Crop_Year'] == 2005,'Area':'Production']
df_assam_18_2005_sum = df_assam_18_2005.sum(axis = 0, skipna = True) 
print(df_assam_18_2005_sum)
print("---------------------------------")
print("Data for Crop_Year = 2006")
print("---------------------------------")
df_assam_18_2006 = df_assam_18.loc[df_assam_18['Crop_Year'] == 2006,'Area':'Production'] 
df_assam_18_2006_sum = df_assam_18_2006.sum(axis = 0, skipna = True)
print(df_assam_18_2006_sum)
print("---------------------------------")
print("Data for Crop_Year = 2007")
print("---------------------------------")
df_assam_18_2007 = df_assam_18.loc[df_assam_18['Crop_Year'] == 2007,'Area':'Production']
df_assam_18_2007_sum = df_assam_18_2007.sum(axis = 0, skipna = True) 
print(df_assam_18_2007_sum)
print("---------------------------------")
print("Data for Crop_Year = 2008")
print("---------------------------------")
df_assam_18_2008 = df_assam_18.loc[df_assam_18['Crop_Year'] == 2008,'Area':'Production']
df_assam_18_2008_sum = df_assam_18_2008.sum(axis = 0, skipna = True) 
print(df_assam_18_2008_sum)
print("---------------------------------")
print("Data for Crop_Year = 2009")
print("---------------------------------")
df_assam_18_2009 = df_assam_18.loc[df_assam_18['Crop_Year'] == 2009,'Area':'Production']
df_assam_18_2009_sum = df_assam_18_2009.sum(axis = 0, skipna = True) 
print(df_assam_18_2009_sum)
print("---------------------------------")
print("Data for Crop_Year = 2010")
print("---------------------------------")
df_assam_18_2010 = df_assam_18.loc[df_assam_18['Crop_Year'] == 2010,'Area':'Production'] 
df_assam_18_2010_sum = df_assam_18_2010.sum(axis = 0, skipna = True)
print(df_assam_18_2010_sum)
print("---------------------------------")
print("Data for Crop_Year = 2011")
print("---------------------------------")
df_assam_18_2011 = df_assam_18.loc[df_assam_18['Crop_Year'] == 2011,'Area':'Production'] 
df_assam_18_2011_sum = df_assam_18_2011.sum(axis = 0, skipna = True)
print(df_assam_18_2011_sum)
print("---------------------------------")
print("Data for Crop_Year = 2012")
print("---------------------------------")
df_assam_18_2012 = df_assam_18.loc[df_assam_18['Crop_Year'] == 2012,'Area':'Production']
df_assam_18_2012_sum = df_assam_18_2012.sum(axis = 0, skipna = True) 
print(df_assam_18_2012_sum)
print("---------------------------------")
print("Data for Crop_Year = 2013")
print("---------------------------------")
df_assam_18_2013 = df_assam_18.loc[df_assam_18['Crop_Year'] == 2013,'Area':'Production'] 
df_assam_18_2013_sum = df_assam_18_2013.sum(axis = 0, skipna = True)
print(df_assam_18_2013_sum)
print("---------------------------------")
print("Data for Crop_Year = 2014")
print("---------------------------------")
df_assam_18_2014 = df_assam_18.loc[df_assam_18['Crop_Year'] == 2014,'Area':'Production']
df_assam_18_2014_sum = df_assam_18_2014.sum(axis = 0, skipna = True) 
print(df_assam_18_2014_sum)
print("---------------------------------")
                   
# details of assam : [19] KOKRAJHAR 

print("---- Details of assam : [19] KOKRAJHAR ------")
df_assam_19 = df_assam[df_assam.District_Name == 'KOKRAJHAR']
        
# Select rows from year =( 1997 to 2014 ) and all columns between 'Area' and 'Production'

print("---------------------------------")
print("Data for Crop_Year = 1997")
print("---------------------------------")
df_assam_19_1997 = df_assam_19.loc[df_assam_19['Crop_Year'] == 1997,'Area':'Production']
df_assam_19_1997_sum = df_assam_19_1997.sum(axis = 0, skipna = True)
print(df_assam_19_1997_sum)
print("---------------------------------")
print("Data for Crop_Year = 1998")
print("---------------------------------")
df_assam_19_1998 = df_assam_19.loc[df_assam_19['Crop_Year'] == 1998,'Area':'Production']
df_assam_19_1998_sum = df_assam_19_1998.sum(axis = 0, skipna = True) 
print(df_assam_19_1998_sum)
print("---------------------------------")
print("Data for Crop_Year = 1999")
print("---------------------------------")
df_assam_19_1999 = df_assam_19.loc[df_assam_19['Crop_Year'] == 1999,'Area':'Production']
df_assam_19_1999_sum = df_assam_19_1999.sum(axis = 0, skipna = True) 
print(df_assam_19_1999_sum)
print("---------------------------------")
print("Data for Crop_Year = 2000")
print("---------------------------------")
df_assam_19_2000 = df_assam_19.loc[df_assam_19['Crop_Year'] == 2000,'Area':'Production']
df_assam_19_2000_sum = df_assam_19_2000.sum(axis = 0, skipna = True) 
print(df_assam_19_2000_sum)
print("---------------------------------")
print("Data for Crop_Year = 2001")
print("---------------------------------")
df_assam_19_2001 = df_assam_19.loc[df_assam_19['Crop_Year'] == 2001,'Area':'Production'] 
df_assam_19_2001_sum = df_assam_19_2001.sum(axis = 0, skipna = True)
print(df_assam_19_2001_sum)
print("---------------------------------")
print("Data for Crop_Year = 2002")
print("---------------------------------")
df_assam_19_2002 = df_assam_19.loc[df_assam_19['Crop_Year'] == 2002,'Area':'Production']
df_assam_19_2002_sum = df_assam_19_2002.sum(axis = 0, skipna = True) 
print(df_assam_19_2002_sum)
print("---------------------------------")
print("Data for Crop_Year = 2003")
print("---------------------------------")
df_assam_19_2003 = df_assam_19.loc[df_assam_19['Crop_Year'] == 2003,'Area':'Production']
df_assam_19_2003_sum = df_assam_19_2003.sum(axis = 0, skipna = True) 
print(df_assam_19_2003_sum)
print("---------------------------------")
print("Data for Crop_Year = 2004")
print("---------------------------------")
df_assam_19_2004 = df_assam_19.loc[df_assam_19['Crop_Year'] == 2004,'Area':'Production']
df_assam_19_2004_sum = df_assam_19_2004.sum(axis = 0, skipna = True) 
print(df_assam_19_2004_sum)
print("---------------------------------")
print("Data for Crop_Year = 2005")
print("---------------------------------")
df_assam_19_2005 = df_assam_19.loc[df_assam_19['Crop_Year'] == 2005,'Area':'Production']
df_assam_19_2005_sum = df_assam_19_2005.sum(axis = 0, skipna = True) 
print(df_assam_19_2005_sum)
print("---------------------------------")
print("Data for Crop_Year = 2006")
print("---------------------------------")
df_assam_19_2006 = df_assam_19.loc[df_assam_19['Crop_Year'] == 2006,'Area':'Production'] 
df_assam_19_2006_sum = df_assam_19_2006.sum(axis = 0, skipna = True)
print(df_assam_19_2006_sum)
print("---------------------------------")
print("Data for Crop_Year = 2007")
print("---------------------------------")
df_assam_19_2007 = df_assam_19.loc[df_assam_19['Crop_Year'] == 2007,'Area':'Production']
df_assam_19_2007_sum = df_assam_19_2007.sum(axis = 0, skipna = True) 
print(df_assam_19_2007_sum)
print("---------------------------------")
print("Data for Crop_Year = 2008")
print("---------------------------------")
df_assam_19_2008 = df_assam_19.loc[df_assam_19['Crop_Year'] == 2008,'Area':'Production']
df_assam_19_2008_sum = df_assam_19_2008.sum(axis = 0, skipna = True) 
print(df_assam_19_2008_sum)
print("---------------------------------")
print("Data for Crop_Year = 2009")
print("---------------------------------")
df_assam_19_2009 = df_assam_19.loc[df_assam_19['Crop_Year'] == 2009,'Area':'Production']
df_assam_19_2009_sum = df_assam_19_2009.sum(axis = 0, skipna = True) 
print(df_assam_19_2009_sum)
print("---------------------------------")
print("Data for Crop_Year = 2010")
print("---------------------------------")
df_assam_19_2010 = df_assam_19.loc[df_assam_19['Crop_Year'] == 2010,'Area':'Production'] 
df_assam_19_2010_sum = df_assam_19_2010.sum(axis = 0, skipna = True)
print(df_assam_19_2010_sum)
print("---------------------------------")
print("Data for Crop_Year = 2011")
print("---------------------------------")
df_assam_19_2011 = df_assam_19.loc[df_assam_19['Crop_Year'] == 2011,'Area':'Production'] 
df_assam_19_2011_sum = df_assam_19_2011.sum(axis = 0, skipna = True)
print(df_assam_19_2011_sum)
print("---------------------------------")
print("Data for Crop_Year = 2012")
print("---------------------------------")
df_assam_19_2012 = df_assam_19.loc[df_assam_19['Crop_Year'] == 2012,'Area':'Production']
df_assam_19_2012_sum = df_assam_19_2012.sum(axis = 0, skipna = True) 
print(df_assam_19_2012_sum)
print("---------------------------------")
print("Data for Crop_Year = 2013")
print("---------------------------------")
df_assam_19_2013 = df_assam_19.loc[df_assam_19['Crop_Year'] == 2013,'Area':'Production'] 
df_assam_19_2013_sum = df_assam_19_2013.sum(axis = 0, skipna = True)
print(df_assam_19_2013_sum)
print("---------------------------------")
print("Data for Crop_Year = 2014")
print("---------------------------------")
df_assam_19_2014 = df_assam_19.loc[df_assam_19['Crop_Year'] == 2014,'Area':'Production']
df_assam_19_2014_sum = df_assam_19_2014.sum(axis = 0, skipna = True) 
print(df_assam_19_2014_sum)
print("---------------------------------")
                                                                  
# details of assam : [20] LAKHIMPUR 

print("---- Details of assam : [20] LAKHIMPUR ------")
df_assam_20 = df_assam[df_assam.District_Name == 'LAKHIMPUR']

# Select rows from year =( 1997 to 2014 ) and all columns between 'Area' and 'Production'

print("---------------------------------")
print("Data for Crop_Year = 1997")
print("---------------------------------")
df_assam_20_1997 = df_assam_20.loc[df_assam_20['Crop_Year'] == 1997,'Area':'Production']
df_assam_20_1997_sum = df_assam_20_1997.sum(axis = 0, skipna = True)
print(df_assam_20_1997_sum)
print("---------------------------------")
print("Data for Crop_Year = 1998")
print("---------------------------------")
df_assam_20_1998 = df_assam_20.loc[df_assam_20['Crop_Year'] == 1998,'Area':'Production']
df_assam_20_1998_sum = df_assam_20_1998.sum(axis = 0, skipna = True) 
print(df_assam_20_1998_sum)
print("---------------------------------")
print("Data for Crop_Year = 1999")
print("---------------------------------")
df_assam_20_1999 = df_assam_20.loc[df_assam_20['Crop_Year'] == 1999,'Area':'Production']
df_assam_20_1999_sum = df_assam_20_1999.sum(axis = 0, skipna = True) 
print(df_assam_20_1999_sum)
print("---------------------------------")
print("Data for Crop_Year = 2000")
print("---------------------------------")
df_assam_20_2000 = df_assam_20.loc[df_assam_20['Crop_Year'] == 2000,'Area':'Production']
df_assam_20_2000_sum = df_assam_20_2000.sum(axis = 0, skipna = True) 
print(df_assam_20_2000_sum)
print("---------------------------------")
print("Data for Crop_Year = 2001")
print("---------------------------------")
df_assam_20_2001 = df_assam_20.loc[df_assam_20['Crop_Year'] == 2001,'Area':'Production'] 
df_assam_20_2001_sum = df_assam_20_2001.sum(axis = 0, skipna = True)
print(df_assam_20_2001_sum)
print("---------------------------------")
print("Data for Crop_Year = 2002")
print("---------------------------------")
df_assam_20_2002 = df_assam_20.loc[df_assam_20['Crop_Year'] == 2002,'Area':'Production']
df_assam_20_2002_sum = df_assam_20_2002.sum(axis = 0, skipna = True) 
print(df_assam_20_2002_sum)
print("---------------------------------")
print("Data for Crop_Year = 2003")
print("---------------------------------")
df_assam_20_2003 = df_assam_20.loc[df_assam_20['Crop_Year'] == 2003,'Area':'Production']
df_assam_20_2003_sum = df_assam_20_2003.sum(axis = 0, skipna = True) 
print(df_assam_20_2003_sum)
print("---------------------------------")
print("Data for Crop_Year = 2004")
print("---------------------------------")
df_assam_20_2004 = df_assam_20.loc[df_assam_20['Crop_Year'] == 2004,'Area':'Production']
df_assam_20_2004_sum = df_assam_20_2004.sum(axis = 0, skipna = True) 
print(df_assam_20_2004_sum)
print("---------------------------------")
print("Data for Crop_Year = 2005")
print("---------------------------------")
df_assam_20_2005 = df_assam_20.loc[df_assam_20['Crop_Year'] == 2005,'Area':'Production']
df_assam_20_2005_sum = df_assam_20_2005.sum(axis = 0, skipna = True) 
print(df_assam_20_2005_sum)
print("---------------------------------")
print("Data for Crop_Year = 2006")
print("---------------------------------")
df_assam_20_2006 = df_assam_20.loc[df_assam_20['Crop_Year'] == 2006,'Area':'Production'] 
df_assam_20_2006_sum = df_assam_20_2006.sum(axis = 0, skipna = True)
print(df_assam_20_2006_sum)
print("---------------------------------")
print("Data for Crop_Year = 2007")
print("---------------------------------")
df_assam_20_2007 = df_assam_20.loc[df_assam_20['Crop_Year'] == 2007,'Area':'Production']
df_assam_20_2007_sum = df_assam_20_2007.sum(axis = 0, skipna = True) 
print(df_assam_20_2007_sum)
print("---------------------------------")
print("Data for Crop_Year = 2008")
print("---------------------------------")
df_assam_20_2008 = df_assam_20.loc[df_assam_20['Crop_Year'] == 2008,'Area':'Production']
df_assam_20_2008_sum = df_assam_20_2008.sum(axis = 0, skipna = True) 
print(df_assam_20_2008_sum)
print("---------------------------------")
print("Data for Crop_Year = 2009")
print("---------------------------------")
df_assam_20_2009 = df_assam_20.loc[df_assam_20['Crop_Year'] == 2009,'Area':'Production']
df_assam_20_2009_sum = df_assam_20_2009.sum(axis = 0, skipna = True) 
print(df_assam_20_2009_sum)
print("---------------------------------")
print("Data for Crop_Year = 2010")
print("---------------------------------")
df_assam_20_2010 = df_assam_20.loc[df_assam_20['Crop_Year'] == 2010,'Area':'Production'] 
df_assam_20_2010_sum = df_assam_20_2010.sum(axis = 0, skipna = True)
print(df_assam_20_2010_sum)
print("---------------------------------")
print("Data for Crop_Year = 2011")
print("---------------------------------")
df_assam_20_2011 = df_assam_20.loc[df_assam_20['Crop_Year'] == 2011,'Area':'Production'] 
df_assam_20_2011_sum = df_assam_20_2011.sum(axis = 0, skipna = True)
print(df_assam_20_2011_sum)
print("---------------------------------")
print("Data for Crop_Year = 2012")
print("---------------------------------")
df_assam_20_2012 = df_assam_20.loc[df_assam_20['Crop_Year'] == 2012,'Area':'Production']
df_assam_20_2012_sum = df_assam_20_2012.sum(axis = 0, skipna = True) 
print(df_assam_20_2012_sum)
print("---------------------------------")
print("Data for Crop_Year = 2013")
print("---------------------------------")
df_assam_20_2013 = df_assam_20.loc[df_assam_20['Crop_Year'] == 2013,'Area':'Production'] 
df_assam_20_2013_sum = df_assam_20_2013.sum(axis = 0, skipna = True)
print(df_assam_20_2013_sum)
print("---------------------------------")
print("Data for Crop_Year = 2014")
print("---------------------------------")
df_assam_20_2014 = df_assam_20.loc[df_assam_20['Crop_Year'] == 2014,'Area':'Production']
df_assam_20_2014_sum = df_assam_20_2014.sum(axis = 0, skipna = True) 
print(df_assam_20_2014_sum)
print("---------------------------------")
                      
# details of assam : [21] MARIGAON 

print("---- Details of assam : [21] MARIGAON ----")
df_assam_21 = df_assam[df_assam.District_Name == 'MARIGAON']

# Select rows from year =( 1997 to 2014 ) and all columns between 'Area' and 'Production'

print("---------------------------------")
print("Data for Crop_Year = 1997")
print("---------------------------------")
df_assam_21_1997 = df_assam_21.loc[df_assam_21['Crop_Year'] == 1997,'Area':'Production']
df_assam_21_1997_sum = df_assam_21_1997.sum(axis = 0, skipna = True)
print(df_assam_21_1997_sum)
print("---------------------------------")
print("Data for Crop_Year = 1998")
print("---------------------------------")
df_assam_21_1998 = df_assam_21.loc[df_assam_21['Crop_Year'] == 1998,'Area':'Production']
df_assam_21_1998_sum = df_assam_21_1998.sum(axis = 0, skipna = True) 
print(df_assam_21_1998_sum)
print("---------------------------------")
print("Data for Crop_Year = 1999")
print("---------------------------------")
df_assam_21_1999 = df_assam_21.loc[df_assam_21['Crop_Year'] == 1999,'Area':'Production']
df_assam_21_1999_sum = df_assam_21_1999.sum(axis = 0, skipna = True) 
print(df_assam_21_1999_sum)
print("---------------------------------")
print("Data for Crop_Year = 2000")
print("---------------------------------")
df_assam_21_2000 = df_assam_21.loc[df_assam_21['Crop_Year'] == 2000,'Area':'Production']
df_assam_21_2000_sum = df_assam_21_2000.sum(axis = 0, skipna = True) 
print(df_assam_21_2000_sum)
print("---------------------------------")
print("Data for Crop_Year = 2001")
print("---------------------------------")
df_assam_21_2001 = df_assam_21.loc[df_assam_21['Crop_Year'] == 2001,'Area':'Production'] 
df_assam_21_2001_sum = df_assam_21_2001.sum(axis = 0, skipna = True)
print(df_assam_21_2001_sum)
print("---------------------------------")
print("Data for Crop_Year = 2002")
print("---------------------------------")
df_assam_21_2002 = df_assam_21.loc[df_assam_21['Crop_Year'] == 2002,'Area':'Production']
df_assam_21_2002_sum = df_assam_21_2002.sum(axis = 0, skipna = True) 
print(df_assam_21_2002_sum)
print("---------------------------------")
print("Data for Crop_Year = 2003")
print("---------------------------------")
df_assam_21_2003 = df_assam_21.loc[df_assam_21['Crop_Year'] == 2003,'Area':'Production']
df_assam_21_2003_sum = df_assam_21_2003.sum(axis = 0, skipna = True) 
print(df_assam_21_2003_sum)
print("---------------------------------")
print("Data for Crop_Year = 2004")
print("---------------------------------")
df_assam_21_2004 = df_assam_21.loc[df_assam_21['Crop_Year'] == 2004,'Area':'Production']
df_assam_21_2004_sum = df_assam_21_2004.sum(axis = 0, skipna = True) 
print(df_assam_21_2004_sum)
print("---------------------------------")
print("Data for Crop_Year = 2005")
print("---------------------------------")
df_assam_21_2005 = df_assam_21.loc[df_assam_21['Crop_Year'] == 2005,'Area':'Production']
df_assam_21_2005_sum = df_assam_21_2005.sum(axis = 0, skipna = True) 
print(df_assam_21_2005_sum)
print("---------------------------------")
print("Data for Crop_Year = 2006")
print("---------------------------------")
df_assam_21_2006 = df_assam_21.loc[df_assam_21['Crop_Year'] == 2006,'Area':'Production'] 
df_assam_21_2006_sum = df_assam_21_2006.sum(axis = 0, skipna = True)
print(df_assam_21_2006_sum)
print("---------------------------------")
print("Data for Crop_Year = 2007")
print("---------------------------------")
df_assam_21_2007 = df_assam_21.loc[df_assam_21['Crop_Year'] == 2007,'Area':'Production']
df_assam_21_2007_sum = df_assam_21_2007.sum(axis = 0, skipna = True) 
print(df_assam_21_2007_sum)
print("---------------------------------")
print("Data for Crop_Year = 2008")
print("---------------------------------")
df_assam_21_2008 = df_assam_21.loc[df_assam_21['Crop_Year'] == 2008,'Area':'Production']
df_assam_21_2008_sum = df_assam_21_2008.sum(axis = 0, skipna = True) 
print(df_assam_21_2008_sum)
print("---------------------------------")
print("Data for Crop_Year = 2009")
print("---------------------------------")
df_assam_21_2009 = df_assam_21.loc[df_assam_21['Crop_Year'] == 2009,'Area':'Production']
df_assam_21_2009_sum = df_assam_21_2009.sum(axis = 0, skipna = True) 
print(df_assam_21_2009_sum)
print("---------------------------------")
print("Data for Crop_Year = 2010")
print("---------------------------------")
df_assam_21_2010 = df_assam_21.loc[df_assam_21['Crop_Year'] == 2010,'Area':'Production'] 
df_assam_21_2010_sum = df_assam_21_2010.sum(axis = 0, skipna = True)
print(df_assam_21_2010_sum)
print("---------------------------------")
print("Data for Crop_Year = 2011")
print("---------------------------------")
df_assam_21_2011 = df_assam_21.loc[df_assam_21['Crop_Year'] == 2011,'Area':'Production'] 
df_assam_21_2011_sum = df_assam_21_2011.sum(axis = 0, skipna = True)
print(df_assam_21_2011_sum)
print("---------------------------------")
print("Data for Crop_Year = 2012")
print("---------------------------------")
df_assam_21_2012 = df_assam_21.loc[df_assam_21['Crop_Year'] == 2012,'Area':'Production']
df_assam_21_2012_sum = df_assam_21_2012.sum(axis = 0, skipna = True) 
print(df_assam_21_2012_sum)
print("---------------------------------")
print("Data for Crop_Year = 2013")
print("---------------------------------")
df_assam_21_2013 = df_assam_21.loc[df_assam_21['Crop_Year'] == 2013,'Area':'Production'] 
df_assam_21_2013_sum = df_assam_21_2013.sum(axis = 0, skipna = True)
print(df_assam_21_2013_sum)
print("---------------------------------")
print("Data for Crop_Year = 2014")
print("---------------------------------")
df_assam_21_2014 = df_assam_21.loc[df_assam_21['Crop_Year'] == 2014,'Area':'Production']
df_assam_21_2014_sum = df_assam_21_2014.sum(axis = 0, skipna = True) 
print(df_assam_21_2014_sum)
print("---------------------------------")
             
# details of assam : [22] NAGAON

print("------ Details of assam : [22] NAGAON ----")
df_assam_22 = df_assam[df_assam.District_Name == 'NAGAON']

# Select rows from year =( 1997 to 2014 ) and all columns between 'Area' and 'Production'

print("---------------------------------")
print("Data for Crop_Year = 1997")
print("---------------------------------")
df_assam_22_1997 = df_assam_22.loc[df_assam_22['Crop_Year'] == 1997,'Area':'Production']
df_assam_22_1997_sum = df_assam_22_1997.sum(axis = 0, skipna = True)
print(df_assam_22_1997_sum)
print("---------------------------------")
print("Data for Crop_Year = 1998")
print("---------------------------------")
df_assam_22_1998 = df_assam_22.loc[df_assam_22['Crop_Year'] == 1998,'Area':'Production']
df_assam_22_1998_sum = df_assam_22_1998.sum(axis = 0, skipna = True) 
print(df_assam_22_1998_sum)
print("---------------------------------")
print("Data for Crop_Year = 1999")
print("---------------------------------")
df_assam_22_1999 = df_assam_22.loc[df_assam_22['Crop_Year'] == 1999,'Area':'Production']
df_assam_22_1999_sum = df_assam_22_1999.sum(axis = 0, skipna = True) 
print(df_assam_22_1999_sum)
print("---------------------------------")
print("Data for Crop_Year = 2000")
print("---------------------------------")
df_assam_22_2000 = df_assam_22.loc[df_assam_22['Crop_Year'] == 2000,'Area':'Production']
df_assam_22_2000_sum = df_assam_22_2000.sum(axis = 0, skipna = True) 
print(df_assam_22_2000_sum)
print("---------------------------------")
print("Data for Crop_Year = 2001")
print("---------------------------------")
df_assam_22_2001 = df_assam_22.loc[df_assam_22['Crop_Year'] == 2001,'Area':'Production'] 
df_assam_22_2001_sum = df_assam_22_2001.sum(axis = 0, skipna = True)
print(df_assam_22_2001_sum)
print("---------------------------------")
print("Data for Crop_Year = 2002")
print("---------------------------------")
df_assam_22_2002 = df_assam_22.loc[df_assam_22['Crop_Year'] == 2002,'Area':'Production']
df_assam_22_2002_sum = df_assam_22_2002.sum(axis = 0, skipna = True) 
print(df_assam_22_2002_sum)
print("---------------------------------")
print("Data for Crop_Year = 2003")
print("---------------------------------")
df_assam_22_2003 = df_assam_22.loc[df_assam_22['Crop_Year'] == 2003,'Area':'Production']
df_assam_22_2003_sum = df_assam_22_2003.sum(axis = 0, skipna = True) 
print(df_assam_22_2003_sum)
print("---------------------------------")
print("Data for Crop_Year = 2004")
print("---------------------------------")
df_assam_22_2004 = df_assam_22.loc[df_assam_22['Crop_Year'] == 2004,'Area':'Production']
df_assam_22_2004_sum = df_assam_22_2004.sum(axis = 0, skipna = True) 
print(df_assam_22_2004_sum)
print("---------------------------------")
print("Data for Crop_Year = 2005")
print("---------------------------------")
df_assam_22_2005 = df_assam_22.loc[df_assam_22['Crop_Year'] == 2005,'Area':'Production']
df_assam_22_2005_sum = df_assam_22_2005.sum(axis = 0, skipna = True) 
print(df_assam_22_2005_sum)
print("---------------------------------")
print("Data for Crop_Year = 2006")
print("---------------------------------")
df_assam_22_2006 = df_assam_22.loc[df_assam_22['Crop_Year'] == 2006,'Area':'Production'] 
df_assam_22_2006_sum = df_assam_22_2006.sum(axis = 0, skipna = True)
print(df_assam_22_2006_sum)
print("---------------------------------")
print("Data for Crop_Year = 2007")
print("---------------------------------")
df_assam_22_2007 = df_assam_22.loc[df_assam_22['Crop_Year'] == 2007,'Area':'Production']
df_assam_22_2007_sum = df_assam_22_2007.sum(axis = 0, skipna = True) 
print(df_assam_22_2007_sum)
print("---------------------------------")
print("Data for Crop_Year = 2008")
print("---------------------------------")
df_assam_22_2008 = df_assam_22.loc[df_assam_22['Crop_Year'] == 2008,'Area':'Production']
df_assam_22_2008_sum = df_assam_22_2008.sum(axis = 0, skipna = True) 
print(df_assam_22_2008_sum)
print("---------------------------------")
print("Data for Crop_Year = 2009")
print("---------------------------------")
df_assam_22_2009 = df_assam_22.loc[df_assam_22['Crop_Year'] == 2009,'Area':'Production']
df_assam_22_2009_sum = df_assam_22_2009.sum(axis = 0, skipna = True) 
print(df_assam_22_2009_sum)
print("---------------------------------")
print("Data for Crop_Year = 2010")
print("---------------------------------")
df_assam_22_2010 = df_assam_22.loc[df_assam_22['Crop_Year'] == 2010,'Area':'Production'] 
df_assam_22_2010_sum = df_assam_22_2010.sum(axis = 0, skipna = True)
print(df_assam_22_2010_sum)
print("---------------------------------")
print("Data for Crop_Year = 2011")
print("---------------------------------")
df_assam_22_2011 = df_assam_22.loc[df_assam_22['Crop_Year'] == 2011,'Area':'Production'] 
df_assam_22_2011_sum = df_assam_22_2011.sum(axis = 0, skipna = True)
print(df_assam_22_2011_sum)
print("---------------------------------")
print("Data for Crop_Year = 2012")
print("---------------------------------")
df_assam_22_2012 = df_assam_22.loc[df_assam_22['Crop_Year'] == 2012,'Area':'Production']
df_assam_22_2012_sum = df_assam_22_2012.sum(axis = 0, skipna = True) 
print(df_assam_22_2012_sum)
print("---------------------------------")
print("Data for Crop_Year = 2013")
print("---------------------------------")
df_assam_22_2013 = df_assam_22.loc[df_assam_22['Crop_Year'] == 2013,'Area':'Production'] 
df_assam_22_2013_sum = df_assam_22_2013.sum(axis = 0, skipna = True)
print(df_assam_22_2013_sum)
print("---------------------------------")
print("Data for Crop_Year = 2014")
print("---------------------------------")
df_assam_22_2014 = df_assam_22.loc[df_assam_22['Crop_Year'] == 2014,'Area':'Production']
df_assam_22_2014_sum = df_assam_22_2014.sum(axis = 0, skipna = True) 
print(df_assam_22_2014_sum)
print("---------------------------------")
                        
# details of assam : [23] NALBARI

print("---- Details of assam : [23] NALBARI ------")
df_assam_23 = df_assam[df_assam.District_Name == 'NALBARI']

# Select rows from year =( 1997 to 2014 ) and all columns between 'Area' and 'Production'

print("---------------------------------")
print("Data for Crop_Year = 1997")
print("---------------------------------")
df_assam_23_1997 = df_assam_23.loc[df_assam_23['Crop_Year'] == 1997,'Area':'Production']
df_assam_23_1997_sum = df_assam_23_1997.sum(axis = 0, skipna = True)
print(df_assam_23_1997_sum)
print("---------------------------------")
print("Data for Crop_Year = 1998")
print("---------------------------------")
df_assam_23_1998 = df_assam_23.loc[df_assam_23['Crop_Year'] == 1998,'Area':'Production']
df_assam_23_1998_sum = df_assam_23_1998.sum(axis = 0, skipna = True) 
print(df_assam_23_1998_sum)
print("---------------------------------")
print("Data for Crop_Year = 1999")
print("---------------------------------")
df_assam_23_1999 = df_assam_23.loc[df_assam_23['Crop_Year'] == 1999,'Area':'Production']
df_assam_23_1999_sum = df_assam_23_1999.sum(axis = 0, skipna = True) 
print(df_assam_23_1999_sum)
print("---------------------------------")
print("Data for Crop_Year = 2000")
print("---------------------------------")
df_assam_23_2000 = df_assam_23.loc[df_assam_23['Crop_Year'] == 2000,'Area':'Production']
df_assam_23_2000_sum = df_assam_23_2000.sum(axis = 0, skipna = True) 
print(df_assam_23_2000_sum)
print("---------------------------------")
print("Data for Crop_Year = 2001")
print("---------------------------------")
df_assam_23_2001 = df_assam_23.loc[df_assam_23['Crop_Year'] == 2001,'Area':'Production'] 
df_assam_23_2001_sum = df_assam_23_2001.sum(axis = 0, skipna = True)
print(df_assam_23_2001_sum)
print("---------------------------------")
print("Data for Crop_Year = 2002")
print("---------------------------------")
df_assam_23_2002 = df_assam_23.loc[df_assam_23['Crop_Year'] == 2002,'Area':'Production']
df_assam_23_2002_sum = df_assam_23_2002.sum(axis = 0, skipna = True) 
print(df_assam_23_2002_sum)
print("---------------------------------")
print("Data for Crop_Year = 2003")
print("---------------------------------")
df_assam_23_2003 = df_assam_23.loc[df_assam_23['Crop_Year'] == 2003,'Area':'Production']
df_assam_23_2003_sum = df_assam_23_2003.sum(axis = 0, skipna = True) 
print(df_assam_23_2003_sum)
print("---------------------------------")
print("Data for Crop_Year = 2004")
print("---------------------------------")
df_assam_23_2004 = df_assam_23.loc[df_assam_23['Crop_Year'] == 2004,'Area':'Production']
df_assam_23_2004_sum = df_assam_23_2004.sum(axis = 0, skipna = True) 
print(df_assam_23_2004_sum)
print("---------------------------------")
print("Data for Crop_Year = 2005")
print("---------------------------------")
df_assam_23_2005 = df_assam_23.loc[df_assam_23['Crop_Year'] == 2005,'Area':'Production']
df_assam_23_2005_sum = df_assam_23_2005.sum(axis = 0, skipna = True) 
print(df_assam_23_2005_sum)
print("---------------------------------")
print("Data for Crop_Year = 2006")
print("---------------------------------")
df_assam_23_2006 = df_assam_23.loc[df_assam_23['Crop_Year'] == 2006,'Area':'Production'] 
df_assam_23_2006_sum = df_assam_23_2006.sum(axis = 0, skipna = True)
print(df_assam_23_2006_sum)
print("---------------------------------")
print("Data for Crop_Year = 2007")
print("---------------------------------")
df_assam_23_2007 = df_assam_23.loc[df_assam_23['Crop_Year'] == 2007,'Area':'Production']
df_assam_23_2007_sum = df_assam_23_2007.sum(axis = 0, skipna = True) 
print(df_assam_23_2007_sum)
print("---------------------------------")
print("Data for Crop_Year = 2008")
print("---------------------------------")
df_assam_23_2008 = df_assam_23.loc[df_assam_23['Crop_Year'] == 2008,'Area':'Production']
df_assam_23_2008_sum = df_assam_23_2008.sum(axis = 0, skipna = True) 
print(df_assam_23_2008_sum)
print("---------------------------------")
print("Data for Crop_Year = 2009")
print("---------------------------------")
df_assam_23_2009 = df_assam_23.loc[df_assam_23['Crop_Year'] == 2009,'Area':'Production']
df_assam_23_2009_sum = df_assam_23_2009.sum(axis = 0, skipna = True) 
print(df_assam_23_2009_sum)
print("---------------------------------")
print("Data for Crop_Year = 2010")
print("---------------------------------")
df_assam_23_2010 = df_assam_23.loc[df_assam_23['Crop_Year'] == 2010,'Area':'Production'] 
df_assam_23_2010_sum = df_assam_23_2010.sum(axis = 0, skipna = True)
print(df_assam_23_2010_sum)
print("---------------------------------")
print("Data for Crop_Year = 2011")
print("---------------------------------")
df_assam_23_2011 = df_assam_23.loc[df_assam_23['Crop_Year'] == 2011,'Area':'Production'] 
df_assam_23_2011_sum = df_assam_23_2011.sum(axis = 0, skipna = True)
print(df_assam_23_2011_sum)
print("---------------------------------")
print("Data for Crop_Year = 2012")
print("---------------------------------")
df_assam_23_2012 = df_assam_23.loc[df_assam_23['Crop_Year'] == 2012,'Area':'Production']
df_assam_23_2012_sum = df_assam_23_2012.sum(axis = 0, skipna = True) 
print(df_assam_23_2012_sum)
print("---------------------------------")
print("Data for Crop_Year = 2013")
print("---------------------------------")
df_assam_23_2013 = df_assam_23.loc[df_assam_23['Crop_Year'] == 2013,'Area':'Production'] 
df_assam_23_2013_sum = df_assam_23_2013.sum(axis = 0, skipna = True)
print(df_assam_23_2013_sum)
print("---------------------------------")
print("Data for Crop_Year = 2014")
print("---------------------------------")
df_assam_23_2014 = df_assam_23.loc[df_assam_23['Crop_Year'] == 2014,'Area':'Production']
df_assam_23_2014_sum = df_assam_23_2014.sum(axis = 0, skipna = True) 
print(df_assam_23_2014_sum)
print("---------------------------------")
                                    
# details of assam : [24] SIVASAGAR 

print("---- Details of assam : [24] SIVASAGAR ---")
df_assam_24 = df_assam[df_assam.District_Name == 'SIVASAGAR']

# Select rows from year =( 1997 to 2014 ) and all columns between 'Area' and 'Production'

print("---------------------------------")
print("Data for Crop_Year = 1997")
print("---------------------------------")
df_assam_24_1997 = df_assam_24.loc[df_assam_24['Crop_Year'] == 1997,'Area':'Production']
df_assam_24_1997_sum = df_assam_24_1997.sum(axis = 0, skipna = True)
print(df_assam_24_1997_sum)
print("---------------------------------")
print("Data for Crop_Year = 1998")
print("---------------------------------")
df_assam_24_1998 = df_assam_24.loc[df_assam_24['Crop_Year'] == 1998,'Area':'Production']
df_assam_24_1998_sum = df_assam_24_1998.sum(axis = 0, skipna = True) 
print(df_assam_24_1998_sum)
print("---------------------------------")
print("Data for Crop_Year = 1999")
print("---------------------------------")
df_assam_24_1999 = df_assam_24.loc[df_assam_24['Crop_Year'] == 1999,'Area':'Production']
df_assam_24_1999_sum = df_assam_24_1999.sum(axis = 0, skipna = True) 
print(df_assam_24_1999_sum)
print("---------------------------------")
print("Data for Crop_Year = 2000")
print("---------------------------------")
df_assam_24_2000 = df_assam_24.loc[df_assam_24['Crop_Year'] == 2000,'Area':'Production']
df_assam_24_2000_sum = df_assam_24_2000.sum(axis = 0, skipna = True) 
print(df_assam_24_2000_sum)
print("---------------------------------")
print("Data for Crop_Year = 2001")
print("---------------------------------")
df_assam_24_2001 = df_assam_24.loc[df_assam_24['Crop_Year'] == 2001,'Area':'Production'] 
df_assam_24_2001_sum = df_assam_24_2001.sum(axis = 0, skipna = True)
print(df_assam_24_2001_sum)
print("---------------------------------")
print("Data for Crop_Year = 2002")
print("---------------------------------")
df_assam_24_2002 = df_assam_24.loc[df_assam_24['Crop_Year'] == 2002,'Area':'Production']
df_assam_24_2002_sum = df_assam_24_2002.sum(axis = 0, skipna = True) 
print(df_assam_24_2002_sum)
print("---------------------------------")
print("Data for Crop_Year = 2003")
print("---------------------------------")
df_assam_24_2003 = df_assam_24.loc[df_assam_24['Crop_Year'] == 2003,'Area':'Production']
df_assam_24_2003_sum = df_assam_24_2003.sum(axis = 0, skipna = True) 
print(df_assam_24_2003_sum)
print("---------------------------------")
print("Data for Crop_Year = 2004")
print("---------------------------------")
df_assam_24_2004 = df_assam_24.loc[df_assam_24['Crop_Year'] == 2004,'Area':'Production']
df_assam_24_2004_sum = df_assam_24_2004.sum(axis = 0, skipna = True) 
print(df_assam_24_2004_sum)
print("---------------------------------")
print("Data for Crop_Year = 2005")
print("---------------------------------")
df_assam_24_2005 = df_assam_24.loc[df_assam_24['Crop_Year'] == 2005,'Area':'Production']
df_assam_24_2005_sum = df_assam_24_2005.sum(axis = 0, skipna = True) 
print(df_assam_24_2005_sum)
print("---------------------------------")
print("Data for Crop_Year = 2006")
print("---------------------------------")
df_assam_24_2006 = df_assam_24.loc[df_assam_24['Crop_Year'] == 2006,'Area':'Production'] 
df_assam_24_2006_sum = df_assam_24_2006.sum(axis = 0, skipna = True)
print(df_assam_24_2006_sum)
print("---------------------------------")
print("Data for Crop_Year = 2007")
print("---------------------------------")
df_assam_24_2007 = df_assam_24.loc[df_assam_24['Crop_Year'] == 2007,'Area':'Production']
df_assam_24_2007_sum = df_assam_24_2007.sum(axis = 0, skipna = True) 
print(df_assam_24_2007_sum)
print("---------------------------------")
print("Data for Crop_Year = 2008")
print("---------------------------------")
df_assam_24_2008 = df_assam_24.loc[df_assam_24['Crop_Year'] == 2008,'Area':'Production']
df_assam_24_2008_sum = df_assam_24_2008.sum(axis = 0, skipna = True) 
print(df_assam_24_2008_sum)
print("---------------------------------")
print("Data for Crop_Year = 2009")
print("---------------------------------")
df_assam_24_2009 = df_assam_24.loc[df_assam_24['Crop_Year'] == 2009,'Area':'Production']
df_assam_24_2009_sum = df_assam_24_2009.sum(axis = 0, skipna = True) 
print(df_assam_24_2009_sum)
print("---------------------------------")
print("Data for Crop_Year = 2010")
print("---------------------------------")
df_assam_24_2010 = df_assam_24.loc[df_assam_24['Crop_Year'] == 2010,'Area':'Production'] 
df_assam_24_2010_sum = df_assam_24_2010.sum(axis = 0, skipna = True)
print(df_assam_24_2010_sum)
print("---------------------------------")
print("Data for Crop_Year = 2011")
print("---------------------------------")
df_assam_24_2011 = df_assam_24.loc[df_assam_24['Crop_Year'] == 2011,'Area':'Production'] 
df_assam_24_2011_sum = df_assam_24_2011.sum(axis = 0, skipna = True)
print(df_assam_24_2011_sum)
print("---------------------------------")
print("Data for Crop_Year = 2012")
print("---------------------------------")
df_assam_24_2012 = df_assam_24.loc[df_assam_24['Crop_Year'] == 2012,'Area':'Production']
df_assam_24_2012_sum = df_assam_24_2012.sum(axis = 0, skipna = True) 
print(df_assam_24_2012_sum)
print("---------------------------------")
print("Data for Crop_Year = 2013")
print("---------------------------------")
df_assam_24_2013 = df_assam_24.loc[df_assam_24['Crop_Year'] == 2013,'Area':'Production'] 
df_assam_24_2013_sum = df_assam_24_2013.sum(axis = 0, skipna = True)
print(df_assam_24_2013_sum)
print("---------------------------------")
print("Data for Crop_Year = 2014")
print("---------------------------------")
df_assam_24_2014 = df_assam_24.loc[df_assam_24['Crop_Year'] == 2014,'Area':'Production']
df_assam_24_2014_sum = df_assam_24_2014.sum(axis = 0, skipna = True) 
print(df_assam_24_2014_sum)
print("---------------------------------")
                              
# details of assam : [25] SONITPUR  

print("----- Details of assam : [25] SONITPUR ----")
df_assam_25 = df_assam[df_assam.District_Name == 'SONITPUR']

# Select rows from year =( 1997 to 2014 ) and all columns between 'Area' and 'Production'

print("---------------------------------")
print("Data for Crop_Year = 1997")
print("---------------------------------")
df_assam_25_1997 = df_assam_25.loc[df_assam_25['Crop_Year'] == 1997,'Area':'Production']
df_assam_25_1997_sum = df_assam_25_1997.sum(axis = 0, skipna = True)
print(df_assam_25_1997_sum)
print("---------------------------------")
print("Data for Crop_Year = 1998")
print("---------------------------------")
df_assam_25_1998 = df_assam_25.loc[df_assam_25['Crop_Year'] == 1998,'Area':'Production']
df_assam_25_1998_sum = df_assam_25_1998.sum(axis = 0, skipna = True) 
print(df_assam_25_1998_sum)
print("---------------------------------")
print("Data for Crop_Year = 1999")
print("---------------------------------")
df_assam_25_1999 = df_assam_25.loc[df_assam_25['Crop_Year'] == 1999,'Area':'Production']
df_assam_25_1999_sum = df_assam_25_1999.sum(axis = 0, skipna = True) 
print(df_assam_25_1999_sum)
print("---------------------------------")
print("Data for Crop_Year = 2000")
print("---------------------------------")
df_assam_25_2000 = df_assam_25.loc[df_assam_25['Crop_Year'] == 2000,'Area':'Production']
df_assam_25_2000_sum = df_assam_25_2000.sum(axis = 0, skipna = True) 
print(df_assam_25_2000_sum)
print("---------------------------------")
print("Data for Crop_Year = 2001")
print("---------------------------------")
df_assam_25_2001 = df_assam_25.loc[df_assam_25['Crop_Year'] == 2001,'Area':'Production'] 
df_assam_25_2001_sum = df_assam_25_2001.sum(axis = 0, skipna = True)
print(df_assam_25_2001_sum)
print("---------------------------------")
print("Data for Crop_Year = 2002")
print("---------------------------------")
df_assam_25_2002 = df_assam_25.loc[df_assam_25['Crop_Year'] == 2002,'Area':'Production']
df_assam_25_2002_sum = df_assam_25_2002.sum(axis = 0, skipna = True) 
print(df_assam_25_2002_sum)
print("---------------------------------")
print("Data for Crop_Year = 2003")
print("---------------------------------")
df_assam_25_2003 = df_assam_25.loc[df_assam_25['Crop_Year'] == 2003,'Area':'Production']
df_assam_25_2003_sum = df_assam_25_2003.sum(axis = 0, skipna = True) 
print(df_assam_25_2003_sum)
print("---------------------------------")
print("Data for Crop_Year = 2004")
print("---------------------------------")
df_assam_25_2004 = df_assam_25.loc[df_assam_25['Crop_Year'] == 2004,'Area':'Production']
df_assam_25_2004_sum = df_assam_25_2004.sum(axis = 0, skipna = True) 
print(df_assam_25_2004_sum)
print("---------------------------------")
print("Data for Crop_Year = 2005")
print("---------------------------------")
df_assam_25_2005 = df_assam_25.loc[df_assam_25['Crop_Year'] == 2005,'Area':'Production']
df_assam_25_2005_sum = df_assam_25_2005.sum(axis = 0, skipna = True) 
print(df_assam_25_2005_sum)
print("---------------------------------")
print("Data for Crop_Year = 2006")
print("---------------------------------")
df_assam_25_2006 = df_assam_25.loc[df_assam_25['Crop_Year'] == 2006,'Area':'Production'] 
df_assam_25_2006_sum = df_assam_25_2006.sum(axis = 0, skipna = True)
print(df_assam_25_2006_sum)
print("---------------------------------")
print("Data for Crop_Year = 2007")
print("---------------------------------")
df_assam_25_2007 = df_assam_25.loc[df_assam_25['Crop_Year'] == 2007,'Area':'Production']
df_assam_25_2007_sum = df_assam_25_2007.sum(axis = 0, skipna = True) 
print(df_assam_25_2007_sum)
print("---------------------------------")
print("Data for Crop_Year = 2008")
print("---------------------------------")
df_assam_25_2008 = df_assam_25.loc[df_assam_25['Crop_Year'] == 2008,'Area':'Production']
df_assam_25_2008_sum = df_assam_25_2008.sum(axis = 0, skipna = True) 
print(df_assam_25_2008_sum)
print("---------------------------------")
print("Data for Crop_Year = 2009")
print("---------------------------------")
df_assam_25_2009 = df_assam_25.loc[df_assam_25['Crop_Year'] == 2009,'Area':'Production']
df_assam_25_2009_sum = df_assam_25_2009.sum(axis = 0, skipna = True) 
print(df_assam_25_2009_sum)
print("---------------------------------")
print("Data for Crop_Year = 2010")
print("---------------------------------")
df_assam_25_2010 = df_assam_25.loc[df_assam_25['Crop_Year'] == 2010,'Area':'Production'] 
df_assam_25_2010_sum = df_assam_25_2010.sum(axis = 0, skipna = True)
print(df_assam_25_2010_sum)
print("---------------------------------")
print("Data for Crop_Year = 2011")
print("---------------------------------")
df_assam_25_2011 = df_assam_25.loc[df_assam_25['Crop_Year'] == 2011,'Area':'Production'] 
df_assam_25_2011_sum = df_assam_25_2011.sum(axis = 0, skipna = True)
print(df_assam_25_2011_sum)
print("---------------------------------")
print("Data for Crop_Year = 2012")
print("---------------------------------")
df_assam_25_2012 = df_assam_25.loc[df_assam_25['Crop_Year'] == 2012,'Area':'Production']
df_assam_25_2012_sum = df_assam_25_2012.sum(axis = 0, skipna = True) 
print(df_assam_25_2012_sum)
print("---------------------------------")
print("Data for Crop_Year = 2013")
print("---------------------------------")
df_assam_25_2013 = df_assam_25.loc[df_assam_25['Crop_Year'] == 2013,'Area':'Production'] 
df_assam_25_2013_sum = df_assam_25_2013.sum(axis = 0, skipna = True)
print(df_assam_25_2013_sum)
print("---------------------------------")
print("Data for Crop_Year = 2014")
print("---------------------------------")
df_assam_25_2014 = df_assam_25.loc[df_assam_25['Crop_Year'] == 2014,'Area':'Production']
df_assam_25_2014_sum = df_assam_25_2014.sum(axis = 0, skipna = True) 
print(df_assam_25_2014_sum)
print("---------------------------------")
            
# details of assam : [26] TINSUKIA

print("--- Details of assam : [26] TINSUKIA ---")
df_assam_26 = df_assam[df_assam.District_Name == 'TINSUKIA']

# Select rows from year =( 1997 to 2014 ) and all columns between 'Area' and 'Production'

print("---------------------------------")
print("Data for Crop_Year = 1997")
print("---------------------------------")
df_assam_26_1997 = df_assam_26.loc[df_assam_26['Crop_Year'] == 1997,'Area':'Production']
df_assam_26_1997_sum = df_assam_26_1997.sum(axis = 0, skipna = True)
print(df_assam_26_1997_sum)
print("---------------------------------")
print("Data for Crop_Year = 1998")
print("---------------------------------")
df_assam_26_1998 = df_assam_26.loc[df_assam_26['Crop_Year'] == 1998,'Area':'Production']
df_assam_26_1998_sum = df_assam_26_1998.sum(axis = 0, skipna = True) 
print(df_assam_26_1998_sum)
print("---------------------------------")
print("Data for Crop_Year = 1999")
print("---------------------------------")
df_assam_26_1999 = df_assam_26.loc[df_assam_26['Crop_Year'] == 1999,'Area':'Production']
df_assam_26_1999_sum = df_assam_26_1999.sum(axis = 0, skipna = True) 
print(df_assam_26_1999_sum)
print("---------------------------------")
print("Data for Crop_Year = 2000")
print("---------------------------------")
df_assam_26_2000 = df_assam_26.loc[df_assam_26['Crop_Year'] == 2000,'Area':'Production']
df_assam_26_2000_sum = df_assam_26_2000.sum(axis = 0, skipna = True) 
print(df_assam_26_2000_sum)
print("---------------------------------")
print("Data for Crop_Year = 2001")
print("---------------------------------")
df_assam_26_2001 = df_assam_26.loc[df_assam_26['Crop_Year'] == 2001,'Area':'Production'] 
df_assam_26_2001_sum = df_assam_26_2001.sum(axis = 0, skipna = True)
print(df_assam_26_2001_sum)
print("---------------------------------")
print("Data for Crop_Year = 2002")
print("---------------------------------")
df_assam_26_2002 = df_assam_26.loc[df_assam_26['Crop_Year'] == 2002,'Area':'Production']
df_assam_26_2002_sum = df_assam_26_2002.sum(axis = 0, skipna = True) 
print(df_assam_26_2002_sum)
print("---------------------------------")
print("Data for Crop_Year = 2003")
print("---------------------------------")
df_assam_26_2003 = df_assam_26.loc[df_assam_26['Crop_Year'] == 2003,'Area':'Production']
df_assam_26_2003_sum = df_assam_26_2003.sum(axis = 0, skipna = True) 
print(df_assam_26_2003_sum)
print("---------------------------------")
print("Data for Crop_Year = 2004")
print("---------------------------------")
df_assam_26_2004 = df_assam_26.loc[df_assam_26['Crop_Year'] == 2004,'Area':'Production']
df_assam_26_2004_sum = df_assam_26_2004.sum(axis = 0, skipna = True) 
print(df_assam_26_2004_sum)
print("---------------------------------")
print("Data for Crop_Year = 2005")
print("---------------------------------")
df_assam_26_2005 = df_assam_26.loc[df_assam_26['Crop_Year'] == 2005,'Area':'Production']
df_assam_26_2005_sum = df_assam_26_2005.sum(axis = 0, skipna = True) 
print(df_assam_26_2005_sum)
print("---------------------------------")
print("Data for Crop_Year = 2006")
print("---------------------------------")
df_assam_26_2006 = df_assam_26.loc[df_assam_26['Crop_Year'] == 2006,'Area':'Production'] 
df_assam_26_2006_sum = df_assam_26_2006.sum(axis = 0, skipna = True)
print(df_assam_26_2006_sum)
print("---------------------------------")
print("Data for Crop_Year = 2007")
print("---------------------------------")
df_assam_26_2007 = df_assam_26.loc[df_assam_26['Crop_Year'] == 2007,'Area':'Production']
df_assam_26_2007_sum = df_assam_26_2007.sum(axis = 0, skipna = True) 
print(df_assam_26_2007_sum)
print("---------------------------------")
print("Data for Crop_Year = 2008")
print("---------------------------------")
df_assam_26_2008 = df_assam_26.loc[df_assam_26['Crop_Year'] == 2008,'Area':'Production']
df_assam_26_2008_sum = df_assam_26_2008.sum(axis = 0, skipna = True) 
print(df_assam_26_2008_sum)
print("---------------------------------")
print("Data for Crop_Year = 2009")
print("---------------------------------")
df_assam_26_2009 = df_assam_26.loc[df_assam_26['Crop_Year'] == 2009,'Area':'Production']
df_assam_26_2009_sum = df_assam_26_2009.sum(axis = 0, skipna = True) 
print(df_assam_26_2009_sum)
print("---------------------------------")
print("Data for Crop_Year = 2010")
print("---------------------------------")
df_assam_26_2010 = df_assam_26.loc[df_assam_26['Crop_Year'] == 2010,'Area':'Production'] 
df_assam_26_2010_sum = df_assam_26_2010.sum(axis = 0, skipna = True)
print(df_assam_26_2010_sum)
print("---------------------------------")
print("Data for Crop_Year = 2011")
print("---------------------------------")
df_assam_26_2011 = df_assam_26.loc[df_assam_26['Crop_Year'] == 2011,'Area':'Production'] 
df_assam_26_2011_sum = df_assam_26_2011.sum(axis = 0, skipna = True)
print(df_assam_26_2011_sum)
print("---------------------------------")
print("Data for Crop_Year = 2012")
print("---------------------------------")
df_assam_26_2012 = df_assam_26.loc[df_assam_26['Crop_Year'] == 2012,'Area':'Production']
df_assam_26_2012_sum = df_assam_26_2012.sum(axis = 0, skipna = True) 
print(df_assam_26_2012_sum)
print("---------------------------------")
print("Data for Crop_Year = 2013")
print("---------------------------------")
df_assam_26_2013 = df_assam_26.loc[df_assam_26['Crop_Year'] == 2013,'Area':'Production'] 
df_assam_26_2013_sum = df_assam_26_2013.sum(axis = 0, skipna = True)
print(df_assam_26_2013_sum)
print("---------------------------------")
print("Data for Crop_Year = 2014")
print("---------------------------------")
df_assam_26_2014 = df_assam_26.loc[df_assam_26['Crop_Year'] == 2014,'Area':'Production']
df_assam_26_2014_sum = df_assam_26_2014.sum(axis = 0, skipna = True) 
print(df_assam_26_2014_sum)
print("---------------------------------")
               
# details of assam : [27] UDALGURI

print("---- Details of assam : [27] UDALGURI -----")
df_assam_27 = df_assam[df_assam.District_Name == 'UDALGURI']

# Select rows from year =( 1997 to 2014 ) and all columns between 'Area' and 'Production'

print("---------------------------------")
print("Data for Crop_Year = 1997")
print("---------------------------------")
df_assam_27_1997 = df_assam_27.loc[df_assam_27['Crop_Year'] == 1997,'Area':'Production']
df_assam_27_1997_sum = df_assam_27_1997.sum(axis = 0, skipna = True)
print(df_assam_27_1997_sum)
print("---------------------------------")
print("Data for Crop_Year = 1998")
print("---------------------------------")
df_assam_27_1998 = df_assam_27.loc[df_assam_27['Crop_Year'] == 1998,'Area':'Production']
df_assam_27_1998_sum = df_assam_27_1998.sum(axis = 0, skipna = True) 
print(df_assam_27_1998_sum)
print("---------------------------------")
print("Data for Crop_Year = 1999")
print("---------------------------------")
df_assam_27_1999 = df_assam_27.loc[df_assam_27['Crop_Year'] == 1999,'Area':'Production']
df_assam_27_1999_sum = df_assam_27_1999.sum(axis = 0, skipna = True) 
print(df_assam_27_1999_sum)
print("---------------------------------")
print("Data for Crop_Year = 2000")
print("---------------------------------")
df_assam_27_2000 = df_assam_27.loc[df_assam_27['Crop_Year'] == 2000,'Area':'Production']
df_assam_27_2000_sum = df_assam_27_2000.sum(axis = 0, skipna = True) 
print(df_assam_27_2000_sum)
print("---------------------------------")
print("Data for Crop_Year = 2001")
print("---------------------------------")
df_assam_27_2001 = df_assam_27.loc[df_assam_27['Crop_Year'] == 2001,'Area':'Production'] 
df_assam_27_2001_sum = df_assam_27_2001.sum(axis = 0, skipna = True)
print(df_assam_27_2001_sum)
print("---------------------------------")
print("Data for Crop_Year = 2002")
print("---------------------------------")
df_assam_27_2002 = df_assam_27.loc[df_assam_27['Crop_Year'] == 2002,'Area':'Production']
df_assam_27_2002_sum = df_assam_27_2002.sum(axis = 0, skipna = True) 
print(df_assam_27_2002_sum)
print("---------------------------------")
print("Data for Crop_Year = 2003")
print("---------------------------------")
df_assam_27_2003 = df_assam_27.loc[df_assam_27['Crop_Year'] == 2003,'Area':'Production']
df_assam_27_2003_sum = df_assam_27_2003.sum(axis = 0, skipna = True) 
print(df_assam_27_2003_sum)
print("---------------------------------")
print("Data for Crop_Year = 2004")
print("---------------------------------")
df_assam_27_2004 = df_assam_27.loc[df_assam_27['Crop_Year'] == 2004,'Area':'Production']
df_assam_27_2004_sum = df_assam_27_2004.sum(axis = 0, skipna = True) 
print(df_assam_27_2004_sum)
print("---------------------------------")
print("Data for Crop_Year = 2005")
print("---------------------------------")
df_assam_27_2005 = df_assam_27.loc[df_assam_27['Crop_Year'] == 2005,'Area':'Production']
df_assam_27_2005_sum = df_assam_27_2005.sum(axis = 0, skipna = True) 
print(df_assam_27_2005_sum)
print("---------------------------------")
print("Data for Crop_Year = 2006")
print("---------------------------------")
df_assam_27_2006 = df_assam_27.loc[df_assam_27['Crop_Year'] == 2006,'Area':'Production'] 
df_assam_27_2006_sum = df_assam_27_2006.sum(axis = 0, skipna = True)
print(df_assam_27_2006_sum)
print("---------------------------------")
print("Data for Crop_Year = 2007")
print("---------------------------------")
df_assam_27_2007 = df_assam_27.loc[df_assam_27['Crop_Year'] == 2007,'Area':'Production']
df_assam_27_2007_sum = df_assam_27_2007.sum(axis = 0, skipna = True) 
print(df_assam_27_2007_sum)
print("---------------------------------")
print("Data for Crop_Year = 2008")
print("---------------------------------")
df_assam_27_2008 = df_assam_27.loc[df_assam_27['Crop_Year'] == 2008,'Area':'Production']
df_assam_27_2008_sum = df_assam_27_2008.sum(axis = 0, skipna = True) 
print(df_assam_27_2008_sum)
print("---------------------------------")
print("Data for Crop_Year = 2009")
print("---------------------------------")
df_assam_27_2009 = df_assam_27.loc[df_assam_27['Crop_Year'] == 2009,'Area':'Production']
df_assam_27_2009_sum = df_assam_27_2009.sum(axis = 0, skipna = True) 
print(df_assam_27_2009_sum)
print("---------------------------------")
print("Data for Crop_Year = 2010")
print("---------------------------------")
df_assam_27_2010 = df_assam_27.loc[df_assam_27['Crop_Year'] == 2010,'Area':'Production'] 
df_assam_27_2010_sum = df_assam_27_2010.sum(axis = 0, skipna = True)
print(df_assam_27_2010_sum)
print("---------------------------------")
print("Data for Crop_Year = 2011")
print("---------------------------------")
df_assam_27_2011 = df_assam_27.loc[df_assam_27['Crop_Year'] == 2011,'Area':'Production'] 
df_assam_27_2011_sum = df_assam_27_2011.sum(axis = 0, skipna = True)
print(df_assam_27_2011_sum)
print("---------------------------------")
print("Data for Crop_Year = 2012")
print("---------------------------------")
df_assam_27_2012 = df_assam_27.loc[df_assam_27['Crop_Year'] == 2012,'Area':'Production']
df_assam_27_2012_sum = df_assam_27_2012.sum(axis = 0, skipna = True) 
print(df_assam_27_2012_sum)
print("---------------------------------")
print("Data for Crop_Year = 2013")
print("---------------------------------")
df_assam_27_2013 = df_assam_27.loc[df_assam_27['Crop_Year'] == 2013,'Area':'Production'] 
df_assam_27_2013_sum = df_assam_27_2013.sum(axis = 0, skipna = True)
print(df_assam_27_2013_sum)
print("---------------------------------")
print("Data for Crop_Year = 2014")
print("---------------------------------")
df_assam_27_2014 = df_assam_27.loc[df_assam_27['Crop_Year'] == 2014,'Area':'Production']
df_assam_27_2014_sum = df_assam_27_2014.sum(axis = 0, skipna = True) 
print(df_assam_27_2014_sum)
print("---------------------------------")


   
# plotting of Assam 'Area' and 'Production'                                                                                                                 
# plotting  Assam : [1] BAKSA                                           
                                               
x1 = ('1997','1998','1999','2000','2001','2002','2003','2004','2005',
     '2006','2007','2008','2009','2010','2011','2012','2013','2014')

y11 =(df_assam_1_1997_sum['Area'],
      df_assam_1_1998_sum['Area'],
      df_assam_1_1999_sum['Area'],
      df_assam_1_2000_sum['Area'],
      df_assam_1_2001_sum['Area'], 
      df_assam_1_2002_sum['Area'],
      df_assam_1_2003_sum['Area'],
      df_assam_1_2004_sum['Area'],
      df_assam_1_2005_sum['Area'],
      df_assam_1_2006_sum['Area'],
      df_assam_1_2007_sum['Area'],
      df_assam_1_2008_sum['Area'],
      df_assam_1_2009_sum['Area'],
      df_assam_1_2010_sum['Area'],
      df_assam_1_2011_sum['Area'],
      df_assam_1_2012_sum['Area'],
      df_assam_1_2013_sum['Area'],
      df_assam_1_2014_sum['Area'])

y22 =(df_assam_1_1997_sum['Production'],
      df_assam_1_1998_sum['Production'],
      df_assam_1_1999_sum['Production'],
      df_assam_1_2000_sum['Production'],
      df_assam_1_2001_sum['Production'], 
      df_assam_1_2002_sum['Production'],
      df_assam_1_2003_sum['Production'],
      df_assam_1_2004_sum['Production'],
      df_assam_1_2005_sum['Production'],
      df_assam_1_2006_sum['Production'],
      df_assam_1_2007_sum['Production'],
      df_assam_1_2008_sum['Production'],
      df_assam_1_2009_sum['Production'],
      df_assam_1_2010_sum['Production'],
      df_assam_1_2011_sum['Production'],
      df_assam_1_2012_sum['Production'],
      df_assam_1_2013_sum['Production'],
      df_assam_1_2014_sum['Production'])                                      

plt.subplot(121)
plt.title('State-4 : Assam : [1] BAKSA (Area) :')
plt.xlabel('year -->')
plt.ylabel('area -->')                                                                      
plt.plot(x1,y11)
plt.show

plt.subplot(122)
plt.title('State-4 : Assam : [1] BAKSA (Production) :')
plt.xlabel('year -->')
plt.ylabel('production -->')
plt.plot(x1,y22)
plt.show() 

# plotting  Assam : [2] BARPETA

x1 = ('1997','1998','1999','2000','2001','2002','2003','2004','2005',
     '2006','2007','2008','2009','2010','2011','2012','2013','2014')

y11 =(df_assam_2_1997_sum['Area'],
      df_assam_2_1998_sum['Area'],
      df_assam_2_1999_sum['Area'],
      df_assam_2_2000_sum['Area'],
      df_assam_2_2001_sum['Area'], 
      df_assam_2_2002_sum['Area'],
      df_assam_2_2003_sum['Area'],
      df_assam_2_2004_sum['Area'],
      df_assam_2_2005_sum['Area'],
      df_assam_2_2006_sum['Area'],
      df_assam_2_2007_sum['Area'],
      df_assam_2_2008_sum['Area'],
      df_assam_2_2009_sum['Area'],
      df_assam_2_2010_sum['Area'],
      df_assam_2_2011_sum['Area'],
      df_assam_2_2012_sum['Area'],
      df_assam_2_2013_sum['Area'],
      df_assam_2_2014_sum['Area'])

y22 =(df_assam_2_1997_sum['Production'],
      df_assam_2_1998_sum['Production'],
      df_assam_2_1999_sum['Production'],
      df_assam_2_2000_sum['Production'],
      df_assam_2_2001_sum['Production'], 
      df_assam_2_2002_sum['Production'],
      df_assam_2_2003_sum['Production'],
      df_assam_2_2004_sum['Production'],
      df_assam_2_2005_sum['Production'],
      df_assam_2_2006_sum['Production'],
      df_assam_2_2007_sum['Production'],
      df_assam_2_2008_sum['Production'],
      df_assam_2_2009_sum['Production'],
      df_assam_2_2010_sum['Production'],
      df_assam_2_2011_sum['Production'],
      df_assam_2_2012_sum['Production'],
      df_assam_2_2013_sum['Production'],
      df_assam_2_2014_sum['Production'])                                      

plt.subplot(121)
plt.title('State-4 : Assam : [2] BARPETA (Area) :')
plt.xlabel('year -->')
plt.ylabel('area -->')                                                                      
plt.plot(x1,y11)
plt.show

plt.subplot(122)
plt.title('State-4 : Assam : [2] BARPETA (Production) :')
plt.xlabel('year -->')
plt.ylabel('production -->')
plt.plot(x1,y22)
plt.show()

# plotting  Assam : [3] BONGAIGAON

x1 = ('1997','1998','1999','2000','2001','2002','2003','2004','2005',
     '2006','2007','2008','2009','2010','2011','2012','2013','2014')

y11 =(df_assam_3_1997_sum['Area'],
      df_assam_3_1998_sum['Area'],
      df_assam_3_1999_sum['Area'],
      df_assam_3_2000_sum['Area'],
      df_assam_3_2001_sum['Area'], 
      df_assam_3_2002_sum['Area'],
      df_assam_3_2003_sum['Area'],
      df_assam_3_2004_sum['Area'],
      df_assam_3_2005_sum['Area'],
      df_assam_3_2006_sum['Area'],
      df_assam_3_2007_sum['Area'],
      df_assam_3_2008_sum['Area'],
      df_assam_3_2009_sum['Area'],
      df_assam_3_2010_sum['Area'],
      df_assam_3_2011_sum['Area'],
      df_assam_3_2012_sum['Area'],
      df_assam_3_2013_sum['Area'],
      df_assam_3_2014_sum['Area'])

y22 =(df_assam_3_1997_sum['Production'],
      df_assam_3_1998_sum['Production'],
      df_assam_3_1999_sum['Production'],
      df_assam_3_2000_sum['Production'],
      df_assam_3_2001_sum['Production'], 
      df_assam_3_2002_sum['Production'],
      df_assam_3_2003_sum['Production'],
      df_assam_3_2004_sum['Production'],
      df_assam_3_2005_sum['Production'],
      df_assam_3_2006_sum['Production'],
      df_assam_3_2007_sum['Production'],
      df_assam_3_2008_sum['Production'],
      df_assam_3_2009_sum['Production'],
      df_assam_3_2010_sum['Production'],
      df_assam_3_2011_sum['Production'],
      df_assam_3_2012_sum['Production'],
      df_assam_3_2013_sum['Production'],
      df_assam_3_2014_sum['Production'])                                      

plt.subplot(121)
plt.title('State-4 : Assam : [3] BONGAIGAON (Area) :')
plt.xlabel('year -->')
plt.ylabel('area -->')                                                                      
plt.plot(x1,y11)
plt.show

plt.subplot(122)
plt.title('State-4 : Assam : [3] BONGAIGAON (Production) :')
plt.xlabel('year -->')
plt.ylabel('production -->')
plt.plot(x1,y22)
plt.show()

# plotting  Assam : [4] CACHAR

x1 = ('1997','1998','1999','2000','2001','2002','2003','2004','2005',
     '2006','2007','2008','2009','2010','2011','2012','2013','2014')

y11 =(df_assam_4_1997_sum['Area'],
      df_assam_4_1998_sum['Area'],
      df_assam_4_1999_sum['Area'],
      df_assam_4_2000_sum['Area'],
      df_assam_4_2001_sum['Area'], 
      df_assam_4_2002_sum['Area'],
      df_assam_4_2003_sum['Area'],
      df_assam_4_2004_sum['Area'],
      df_assam_4_2005_sum['Area'],
      df_assam_4_2006_sum['Area'],
      df_assam_4_2007_sum['Area'],
      df_assam_4_2008_sum['Area'],
      df_assam_4_2009_sum['Area'],
      df_assam_4_2010_sum['Area'],
      df_assam_4_2011_sum['Area'],
      df_assam_4_2012_sum['Area'],
      df_assam_4_2013_sum['Area'],
      df_assam_4_2014_sum['Area'])

y22 =(df_assam_4_1997_sum['Production'],
      df_assam_4_1998_sum['Production'],
      df_assam_4_1999_sum['Production'],
      df_assam_4_2000_sum['Production'],
      df_assam_4_2001_sum['Production'], 
      df_assam_4_2002_sum['Production'],
      df_assam_4_2003_sum['Production'],
      df_assam_4_2004_sum['Production'],
      df_assam_4_2005_sum['Production'],
      df_assam_4_2006_sum['Production'],
      df_assam_4_2007_sum['Production'],
      df_assam_4_2008_sum['Production'],
      df_assam_4_2009_sum['Production'],
      df_assam_4_2010_sum['Production'],
      df_assam_4_2011_sum['Production'],
      df_assam_4_2012_sum['Production'],
      df_assam_4_2013_sum['Production'],
      df_assam_4_2014_sum['Production'])                                      

plt.subplot(121)
plt.title('State-4 : Assam : [4] CACHAR (Area) :')
plt.xlabel('year -->')
plt.ylabel('area -->')                                                                      
plt.plot(x1,y11)
plt.show

plt.subplot(122)
plt.title('State-4 : Assam : [4] CACHAR (Production) :')
plt.xlabel('year -->')
plt.ylabel('production -->')
plt.plot(x1,y22)
plt.show()

# plotting  Assam : [5] CHIRANG

x1 = ('1997','1998','1999','2000','2001','2002','2003','2004','2005',
     '2006','2007','2008','2009','2010','2011','2012','2013','2014')

y11 =(df_assam_5_1997_sum['Area'],
      df_assam_5_1998_sum['Area'],
      df_assam_5_1999_sum['Area'],
      df_assam_5_2000_sum['Area'],
      df_assam_5_2001_sum['Area'], 
      df_assam_5_2002_sum['Area'],
      df_assam_5_2003_sum['Area'],
      df_assam_5_2004_sum['Area'],
      df_assam_5_2005_sum['Area'],
      df_assam_5_2006_sum['Area'],
      df_assam_5_2007_sum['Area'],
      df_assam_5_2008_sum['Area'],
      df_assam_5_2009_sum['Area'],
      df_assam_5_2010_sum['Area'],
      df_assam_5_2011_sum['Area'],
      df_assam_5_2012_sum['Area'],
      df_assam_5_2013_sum['Area'],
      df_assam_5_2014_sum['Area'])

y22 =(df_assam_5_1997_sum['Production'],
      df_assam_5_1998_sum['Production'],
      df_assam_5_1999_sum['Production'],
      df_assam_5_2000_sum['Production'],
      df_assam_5_2001_sum['Production'], 
      df_assam_5_2002_sum['Production'],
      df_assam_5_2003_sum['Production'],
      df_assam_5_2004_sum['Production'],
      df_assam_5_2005_sum['Production'],
      df_assam_5_2006_sum['Production'],
      df_assam_5_2007_sum['Production'],
      df_assam_5_2008_sum['Production'],
      df_assam_5_2009_sum['Production'],
      df_assam_5_2010_sum['Production'],
      df_assam_5_2011_sum['Production'],
      df_assam_5_2012_sum['Production'],
      df_assam_5_2013_sum['Production'],
      df_assam_5_2014_sum['Production'])                                      

plt.subplot(121)
plt.title('State-4 : Assam : [5] CHIRANG (Area) :')
plt.xlabel('year -->')
plt.ylabel('area -->')                                                                      
plt.plot(x1,y11)
plt.show

plt.subplot(122)
plt.title('State-4 : Assam : [5] CHIRANG (Production) :')
plt.xlabel('year -->')
plt.ylabel('production -->')
plt.plot(x1,y22)
plt.show()

# plotting  Assam : [6] DARRANG

x1 = ('1997','1998','1999','2000','2001','2002','2003','2004','2005',
     '2006','2007','2008','2009','2010','2011','2012','2013','2014')

y11 =(df_assam_6_1997_sum['Area'],
      df_assam_6_1998_sum['Area'],
      df_assam_6_1999_sum['Area'],
      df_assam_6_2000_sum['Area'],
      df_assam_6_2001_sum['Area'], 
      df_assam_6_2002_sum['Area'],
      df_assam_6_2003_sum['Area'],
      df_assam_6_2004_sum['Area'],
      df_assam_6_2005_sum['Area'],
      df_assam_6_2006_sum['Area'],
      df_assam_6_2007_sum['Area'],
      df_assam_6_2008_sum['Area'],
      df_assam_6_2009_sum['Area'],
      df_assam_6_2010_sum['Area'],
      df_assam_6_2011_sum['Area'],
      df_assam_6_2012_sum['Area'],
      df_assam_6_2013_sum['Area'],
      df_assam_6_2014_sum['Area'])

y22 =(df_assam_6_1997_sum['Production'],
      df_assam_6_1998_sum['Production'],
      df_assam_6_1999_sum['Production'],
      df_assam_6_2000_sum['Production'],
      df_assam_6_2001_sum['Production'], 
      df_assam_6_2002_sum['Production'],
      df_assam_6_2003_sum['Production'],
      df_assam_6_2004_sum['Production'],
      df_assam_6_2005_sum['Production'],
      df_assam_6_2006_sum['Production'],
      df_assam_6_2007_sum['Production'],
      df_assam_6_2008_sum['Production'],
      df_assam_6_2009_sum['Production'],
      df_assam_6_2010_sum['Production'],
      df_assam_6_2011_sum['Production'],
      df_assam_6_2012_sum['Production'],
      df_assam_6_2013_sum['Production'],
      df_assam_6_2014_sum['Production'])                                      

plt.subplot(121)
plt.title('State-4 : Assam : [6] DARRANG (Area) :')
plt.xlabel('year -->')
plt.ylabel('area -->')                                                                      
plt.plot(x1,y11)
plt.show

plt.subplot(122)
plt.title('State-4 : Assam : [6] DARRANG (Production) :')
plt.xlabel('year -->')
plt.ylabel('production -->')
plt.plot(x1,y22)
plt.show()

# plotting  Assam : [7] DHEMAJI

x1 = ('1997','1998','1999','2000','2001','2002','2003','2004','2005',
     '2006','2007','2008','2009','2010','2011','2012','2013','2014')

y11 =(df_assam_7_1997_sum['Area'],
      df_assam_7_1998_sum['Area'],
      df_assam_7_1999_sum['Area'],
      df_assam_7_2000_sum['Area'],
      df_assam_7_2001_sum['Area'], 
      df_assam_7_2002_sum['Area'],
      df_assam_7_2003_sum['Area'],
      df_assam_7_2004_sum['Area'],
      df_assam_7_2005_sum['Area'],
      df_assam_7_2006_sum['Area'],
      df_assam_7_2007_sum['Area'],
      df_assam_7_2008_sum['Area'],
      df_assam_7_2009_sum['Area'],
      df_assam_7_2010_sum['Area'],
      df_assam_7_2011_sum['Area'],
      df_assam_7_2012_sum['Area'],
      df_assam_7_2013_sum['Area'],
      df_assam_7_2014_sum['Area'])

y22 =(df_assam_7_1997_sum['Production'],
      df_assam_7_1998_sum['Production'],
      df_assam_7_1999_sum['Production'],
      df_assam_7_2000_sum['Production'],
      df_assam_7_2001_sum['Production'], 
      df_assam_7_2002_sum['Production'],
      df_assam_7_2003_sum['Production'],
      df_assam_7_2004_sum['Production'],
      df_assam_7_2005_sum['Production'],
      df_assam_7_2006_sum['Production'],
      df_assam_7_2007_sum['Production'],
      df_assam_7_2008_sum['Production'],
      df_assam_7_2009_sum['Production'],
      df_assam_7_2010_sum['Production'],
      df_assam_7_2011_sum['Production'],
      df_assam_7_2012_sum['Production'],
      df_assam_7_2013_sum['Production'],
      df_assam_7_2014_sum['Production'])                                      

plt.subplot(121)
plt.title('State-4 : Assam : [7] DHEMAJI (Area) :')
plt.xlabel('year -->')
plt.ylabel('area -->')                                                                      
plt.plot(x1,y11)
plt.show

plt.subplot(122)
plt.title('State-4 : Assam : [7] DHEMAJI (Production) :')
plt.xlabel('year -->')
plt.ylabel('production -->')
plt.plot(x1,y22)
plt.show()

# plotting  Assam : [8] DHUBRI

x1 = ('1997','1998','1999','2000','2001','2002','2003','2004','2005',
     '2006','2007','2008','2009','2010','2011','2012','2013','2014')

y11 =(df_assam_8_1997_sum['Area'],
      df_assam_8_1998_sum['Area'],
      df_assam_8_1999_sum['Area'],
      df_assam_8_2000_sum['Area'],
      df_assam_8_2001_sum['Area'], 
      df_assam_8_2002_sum['Area'],
      df_assam_8_2003_sum['Area'],
      df_assam_8_2004_sum['Area'],
      df_assam_8_2005_sum['Area'],
      df_assam_8_2006_sum['Area'],
      df_assam_8_2007_sum['Area'],
      df_assam_8_2008_sum['Area'],
      df_assam_8_2009_sum['Area'],
      df_assam_8_2010_sum['Area'],
      df_assam_8_2011_sum['Area'],
      df_assam_8_2012_sum['Area'],
      df_assam_8_2013_sum['Area'],
      df_assam_8_2014_sum['Area'])

y22 =(df_assam_8_1997_sum['Production'],
      df_assam_8_1998_sum['Production'],
      df_assam_8_1999_sum['Production'],
      df_assam_8_2000_sum['Production'],
      df_assam_8_2001_sum['Production'], 
      df_assam_8_2002_sum['Production'],
      df_assam_8_2003_sum['Production'],
      df_assam_8_2004_sum['Production'],
      df_assam_8_2005_sum['Production'],
      df_assam_8_2006_sum['Production'],
      df_assam_8_2007_sum['Production'],
      df_assam_8_2008_sum['Production'],
      df_assam_8_2009_sum['Production'],
      df_assam_8_2010_sum['Production'],
      df_assam_8_2011_sum['Production'],
      df_assam_8_2012_sum['Production'],
      df_assam_8_2013_sum['Production'],
      df_assam_8_2014_sum['Production'])                                      

plt.subplot(121)
plt.title('State-4 : Assam : [8] DHUBRI (Area) :')
plt.xlabel('year -->')
plt.ylabel('area -->')                                                                      
plt.plot(x1,y11)
plt.show

plt.subplot(122)
plt.title('State-4 : Assam : [8] DHUBRI (Production) :')
plt.xlabel('year -->')
plt.ylabel('production -->')
plt.plot(x1,y22)
plt.show()

# plotting  Assam : [9] DIBRUGARH

x1 = ('1997','1998','1999','2000','2001','2002','2003','2004','2005',
     '2006','2007','2008','2009','2010','2011','2012','2013','2014')

y11 =(df_assam_9_1997_sum['Area'],
      df_assam_9_1998_sum['Area'],
      df_assam_9_1999_sum['Area'],
      df_assam_9_2000_sum['Area'],
      df_assam_9_2001_sum['Area'], 
      df_assam_9_2002_sum['Area'],
      df_assam_9_2003_sum['Area'],
      df_assam_9_2004_sum['Area'],
      df_assam_9_2005_sum['Area'],
      df_assam_9_2006_sum['Area'],
      df_assam_9_2007_sum['Area'],
      df_assam_9_2008_sum['Area'],
      df_assam_9_2009_sum['Area'],
      df_assam_9_2010_sum['Area'],
      df_assam_9_2011_sum['Area'],
      df_assam_9_2012_sum['Area'],
      df_assam_9_2013_sum['Area'],
      df_assam_9_2014_sum['Area'])

y22 =(df_assam_9_1997_sum['Production'],
      df_assam_9_1998_sum['Production'],
      df_assam_9_1999_sum['Production'],
      df_assam_9_2000_sum['Production'],
      df_assam_9_2001_sum['Production'], 
      df_assam_9_2002_sum['Production'],
      df_assam_9_2003_sum['Production'],
      df_assam_9_2004_sum['Production'],
      df_assam_9_2005_sum['Production'],
      df_assam_9_2006_sum['Production'],
      df_assam_9_2007_sum['Production'],
      df_assam_9_2008_sum['Production'],
      df_assam_9_2009_sum['Production'],
      df_assam_9_2010_sum['Production'],
      df_assam_9_2011_sum['Production'],
      df_assam_9_2012_sum['Production'],
      df_assam_9_2013_sum['Production'],
      df_assam_9_2014_sum['Production'])                                      

plt.subplot(121)
plt.title('State-4 : Assam : [9] DIBRUGARH (Area) :')
plt.xlabel('year -->')
plt.ylabel('area -->')                                                                      
plt.plot(x1,y11)
plt.show

plt.subplot(122)
plt.title('State-4 : Assam : [9] DIBRUGARH (Production) :')
plt.xlabel('year -->')
plt.ylabel('production -->')
plt.plot(x1,y22)
plt.show()

# plotting  Assam : [10] DIMA HASAO

x1 = ('1997','1998','1999','2000','2001','2002','2003','2004','2005',
     '2006','2007','2008','2009','2010','2011','2012','2013','2014')

y11 =(df_assam_10_1997_sum['Area'],
      df_assam_10_1998_sum['Area'],
      df_assam_10_1999_sum['Area'],
      df_assam_10_2000_sum['Area'],
      df_assam_10_2001_sum['Area'], 
      df_assam_10_2002_sum['Area'],
      df_assam_10_2003_sum['Area'],
      df_assam_10_2004_sum['Area'],
      df_assam_10_2005_sum['Area'],
      df_assam_10_2006_sum['Area'],
      df_assam_10_2007_sum['Area'],
      df_assam_10_2008_sum['Area'],
      df_assam_10_2009_sum['Area'],
      df_assam_10_2010_sum['Area'],
      df_assam_10_2011_sum['Area'],
      df_assam_10_2012_sum['Area'],
      df_assam_10_2013_sum['Area'],
      df_assam_10_2014_sum['Area'])

y22 =(df_assam_10_1997_sum['Production'],
      df_assam_10_1998_sum['Production'],
      df_assam_10_1999_sum['Production'],
      df_assam_10_2000_sum['Production'],
      df_assam_10_2001_sum['Production'], 
      df_assam_10_2002_sum['Production'],
      df_assam_10_2003_sum['Production'],
      df_assam_10_2004_sum['Production'],
      df_assam_10_2005_sum['Production'],
      df_assam_10_2006_sum['Production'],
      df_assam_10_2007_sum['Production'],
      df_assam_10_2008_sum['Production'],
      df_assam_10_2009_sum['Production'],
      df_assam_10_2010_sum['Production'],
      df_assam_10_2011_sum['Production'],
      df_assam_10_2012_sum['Production'],
      df_assam_10_2013_sum['Production'],
      df_assam_10_2014_sum['Production'])                                      

plt.subplot(121)
plt.title('State-4 : Assam : [10] DIMA HASAO (Area) :')
plt.xlabel('year -->')
plt.ylabel('area -->')                                                                      
plt.plot(x1,y11)
plt.show

plt.subplot(122)
plt.title('State-4 : Assam : [10] DIMA HASAO (Production) :')
plt.xlabel('year -->')
plt.ylabel('production -->')
plt.plot(x1,y22)
plt.show()

# plotting  Assam : [11] GOALPARA

x1 = ('1997','1998','1999','2000','2001','2002','2003','2004','2005',
     '2006','2007','2008','2009','2010','2011','2012','2013','2014')

y11 =(df_assam_11_1997_sum['Area'],
      df_assam_11_1998_sum['Area'],
      df_assam_11_1999_sum['Area'],
      df_assam_11_2000_sum['Area'],
      df_assam_11_2001_sum['Area'], 
      df_assam_11_2002_sum['Area'],
      df_assam_11_2003_sum['Area'],
      df_assam_11_2004_sum['Area'],
      df_assam_11_2005_sum['Area'],
      df_assam_11_2006_sum['Area'],
      df_assam_11_2007_sum['Area'],
      df_assam_11_2008_sum['Area'],
      df_assam_11_2009_sum['Area'],
      df_assam_11_2010_sum['Area'],
      df_assam_11_2011_sum['Area'],
      df_assam_11_2012_sum['Area'],
      df_assam_11_2013_sum['Area'],
      df_assam_11_2014_sum['Area'])

y22 =(df_assam_11_1997_sum['Production'],
      df_assam_11_1998_sum['Production'],
      df_assam_11_1999_sum['Production'],
      df_assam_11_2000_sum['Production'],
      df_assam_11_2001_sum['Production'], 
      df_assam_11_2002_sum['Production'],
      df_assam_11_2003_sum['Production'],
      df_assam_11_2004_sum['Production'],
      df_assam_11_2005_sum['Production'],
      df_assam_11_2006_sum['Production'],
      df_assam_11_2007_sum['Production'],
      df_assam_11_2008_sum['Production'],
      df_assam_11_2009_sum['Production'],
      df_assam_11_2010_sum['Production'],
      df_assam_11_2011_sum['Production'],
      df_assam_11_2012_sum['Production'],
      df_assam_11_2013_sum['Production'],
      df_assam_11_2014_sum['Production'])                                      

plt.subplot(121)
plt.title('State-4 : Assam : [11] GOALPARA (Area) :')
plt.xlabel('year -->')
plt.ylabel('area -->')                                                                      
plt.plot(x1,y11)
plt.show

plt.subplot(122)
plt.title('State-4 : Assam : [11] GOALPARA (Production) :')
plt.xlabel('year -->')
plt.ylabel('production -->')
plt.plot(x1,y22)
plt.show()

# plotting  Assam : [12] GOLAGHAT

x1 = ('1997','1998','1999','2000','2001','2002','2003','2004','2005',
     '2006','2007','2008','2009','2010','2011','2012','2013','2014')

y11 =(df_assam_12_1997_sum['Area'],
      df_assam_12_1998_sum['Area'],
      df_assam_12_1999_sum['Area'],
      df_assam_12_2000_sum['Area'],
      df_assam_12_2001_sum['Area'], 
      df_assam_12_2002_sum['Area'],
      df_assam_12_2003_sum['Area'],
      df_assam_12_2004_sum['Area'],
      df_assam_12_2005_sum['Area'],
      df_assam_12_2006_sum['Area'],
      df_assam_12_2007_sum['Area'],
      df_assam_12_2008_sum['Area'],
      df_assam_12_2009_sum['Area'],
      df_assam_12_2010_sum['Area'],
      df_assam_12_2011_sum['Area'],
      df_assam_12_2012_sum['Area'],
      df_assam_12_2013_sum['Area'],
      df_assam_12_2014_sum['Area'])

y22 =(df_assam_12_1997_sum['Production'],
      df_assam_12_1998_sum['Production'],
      df_assam_12_1999_sum['Production'],
      df_assam_12_2000_sum['Production'],
      df_assam_12_2001_sum['Production'], 
      df_assam_12_2002_sum['Production'],
      df_assam_12_2003_sum['Production'],
      df_assam_12_2004_sum['Production'],
      df_assam_12_2005_sum['Production'],
      df_assam_12_2006_sum['Production'],
      df_assam_12_2007_sum['Production'],
      df_assam_12_2008_sum['Production'],
      df_assam_12_2009_sum['Production'],
      df_assam_12_2010_sum['Production'],
      df_assam_12_2011_sum['Production'],
      df_assam_12_2012_sum['Production'],
      df_assam_12_2013_sum['Production'],
      df_assam_12_2014_sum['Production'])                                      

plt.subplot(121)
plt.title('State-4 : Assam : [12] GOLAGHAT (Area) :')
plt.xlabel('year -->')
plt.ylabel('area -->')                                                                      
plt.plot(x1,y11)
plt.show

plt.subplot(122)
plt.title('State-4 : Assam : [12] GOLAGHAT (Production) :')
plt.xlabel('year -->')
plt.ylabel('production -->')
plt.plot(x1,y22)
plt.show()

# plotting  Assam : [13] HAILAKANDI

x1 = ('1997','1998','1999','2000','2001','2002','2003','2004','2005',
     '2006','2007','2008','2009','2010','2011','2012','2013','2014')

y11 =(df_assam_13_1997_sum['Area'],
      df_assam_13_1998_sum['Area'],
      df_assam_13_1999_sum['Area'],
      df_assam_13_2000_sum['Area'],
      df_assam_13_2001_sum['Area'], 
      df_assam_13_2002_sum['Area'],
      df_assam_13_2003_sum['Area'],
      df_assam_13_2004_sum['Area'],
      df_assam_13_2005_sum['Area'],
      df_assam_13_2006_sum['Area'],
      df_assam_13_2007_sum['Area'],
      df_assam_13_2008_sum['Area'],
      df_assam_13_2009_sum['Area'],
      df_assam_13_2010_sum['Area'],
      df_assam_13_2011_sum['Area'],
      df_assam_13_2012_sum['Area'],
      df_assam_13_2013_sum['Area'],
      df_assam_13_2014_sum['Area'])

y22 =(df_assam_13_1997_sum['Production'],
      df_assam_13_1998_sum['Production'],
      df_assam_13_1999_sum['Production'],
      df_assam_13_2000_sum['Production'],
      df_assam_13_2001_sum['Production'], 
      df_assam_13_2002_sum['Production'],
      df_assam_13_2003_sum['Production'],
      df_assam_13_2004_sum['Production'],
      df_assam_13_2005_sum['Production'],
      df_assam_13_2006_sum['Production'],
      df_assam_13_2007_sum['Production'],
      df_assam_13_2008_sum['Production'],
      df_assam_13_2009_sum['Production'],
      df_assam_13_2010_sum['Production'],
      df_assam_13_2011_sum['Production'],
      df_assam_13_2012_sum['Production'],
      df_assam_13_2013_sum['Production'],
      df_assam_13_2014_sum['Production'])                                      

plt.subplot(121)
plt.title('State-4 : Assam : [13] HAILAKANDI (Area) :')
plt.xlabel('year -->')
plt.ylabel('area -->')                                                                      
plt.plot(x1,y11)
plt.show

plt.subplot(122)
plt.title('State-4 : Assam : [13] HAILAKANDI (Production) :')
plt.xlabel('year -->')
plt.ylabel('production -->')
plt.plot(x1,y22)
plt.show()

# plotting  Assam : [14] JORHAT

x1 = ('1997','1998','1999','2000','2001','2002','2003','2004','2005',
     '2006','2007','2008','2009','2010','2011','2012','2013','2014')

y11 =(df_assam_14_1997_sum['Area'],
      df_assam_14_1998_sum['Area'],
      df_assam_14_1999_sum['Area'],
      df_assam_14_2000_sum['Area'],
      df_assam_14_2001_sum['Area'], 
      df_assam_14_2002_sum['Area'],
      df_assam_14_2003_sum['Area'],
      df_assam_14_2004_sum['Area'],
      df_assam_14_2005_sum['Area'],
      df_assam_14_2006_sum['Area'],
      df_assam_14_2007_sum['Area'],
      df_assam_14_2008_sum['Area'],
      df_assam_14_2009_sum['Area'],
      df_assam_14_2010_sum['Area'],
      df_assam_14_2011_sum['Area'],
      df_assam_14_2012_sum['Area'],
      df_assam_14_2013_sum['Area'],
      df_assam_14_2014_sum['Area'])

y22 =(df_assam_14_1997_sum['Production'],
      df_assam_14_1998_sum['Production'],
      df_assam_14_1999_sum['Production'],
      df_assam_14_2000_sum['Production'],
      df_assam_14_2001_sum['Production'], 
      df_assam_14_2002_sum['Production'],
      df_assam_14_2003_sum['Production'],
      df_assam_14_2004_sum['Production'],
      df_assam_14_2005_sum['Production'],
      df_assam_14_2006_sum['Production'],
      df_assam_14_2007_sum['Production'],
      df_assam_14_2008_sum['Production'],
      df_assam_14_2009_sum['Production'],
      df_assam_14_2010_sum['Production'],
      df_assam_14_2011_sum['Production'],
      df_assam_14_2012_sum['Production'],
      df_assam_14_2013_sum['Production'],
      df_assam_14_2014_sum['Production'])                                      

plt.subplot(121)
plt.title('State-4 : Assam : [14] JORHAT (Area) :')
plt.xlabel('year -->')
plt.ylabel('area -->')                                                                      
plt.plot(x1,y11)
plt.show

plt.subplot(122)
plt.title('State-4 : Assam : [14] JORHAT(Production) :')
plt.xlabel('year -->')
plt.ylabel('production -->')
plt.plot(x1,y22)
plt.show()

# plotting  Assam : [15] KAMRUP

x1 = ('1997','1998','1999','2000','2001','2002','2003','2004','2005',
     '2006','2007','2008','2009','2010','2011','2012','2013','2014')

y11 =(df_assam_15_1997_sum['Area'],
      df_assam_15_1998_sum['Area'],
      df_assam_15_1999_sum['Area'],
      df_assam_15_2000_sum['Area'],
      df_assam_15_2001_sum['Area'], 
      df_assam_15_2002_sum['Area'],
      df_assam_15_2003_sum['Area'],
      df_assam_15_2004_sum['Area'],
      df_assam_15_2005_sum['Area'],
      df_assam_15_2006_sum['Area'],
      df_assam_15_2007_sum['Area'],
      df_assam_15_2008_sum['Area'],
      df_assam_15_2009_sum['Area'],
      df_assam_15_2010_sum['Area'],
      df_assam_15_2011_sum['Area'],
      df_assam_15_2012_sum['Area'],
      df_assam_15_2013_sum['Area'],
      df_assam_15_2014_sum['Area'])

y22 =(df_assam_15_1997_sum['Production'],
      df_assam_15_1998_sum['Production'],
      df_assam_15_1999_sum['Production'],
      df_assam_15_2000_sum['Production'],
      df_assam_15_2001_sum['Production'], 
      df_assam_15_2002_sum['Production'],
      df_assam_15_2003_sum['Production'],
      df_assam_15_2004_sum['Production'],
      df_assam_15_2005_sum['Production'],
      df_assam_15_2006_sum['Production'],
      df_assam_15_2007_sum['Production'],
      df_assam_15_2008_sum['Production'],
      df_assam_15_2009_sum['Production'],
      df_assam_15_2010_sum['Production'],
      df_assam_15_2011_sum['Production'],
      df_assam_15_2012_sum['Production'],
      df_assam_15_2013_sum['Production'],
      df_assam_15_2014_sum['Production'])                                      

plt.subplot(121)
plt.title('State-4 : Assam : [15] KAMRUP (Area) :')
plt.xlabel('year -->')
plt.ylabel('area -->')                                                                      
plt.plot(x1,y11)
plt.show

plt.subplot(122)
plt.title('State-4 : Assam : [15] KAMRUP (Production) :')
plt.xlabel('year -->')
plt.ylabel('production -->')
plt.plot(x1,y22)
plt.show()

# plotting  Assam : [16] KAMRUP METRO

x1 = ('1997','1998','1999','2000','2001','2002','2003','2004','2005',
     '2006','2007','2008','2009','2010','2011','2012','2013','2014')

y11 =(df_assam_16_1997_sum['Area'],
      df_assam_16_1998_sum['Area'],
      df_assam_16_1999_sum['Area'],
      df_assam_16_2000_sum['Area'],
      df_assam_16_2001_sum['Area'], 
      df_assam_16_2002_sum['Area'],
      df_assam_16_2003_sum['Area'],
      df_assam_16_2004_sum['Area'],
      df_assam_16_2005_sum['Area'],
      df_assam_16_2006_sum['Area'],
      df_assam_16_2007_sum['Area'],
      df_assam_16_2008_sum['Area'],
      df_assam_16_2009_sum['Area'],
      df_assam_16_2010_sum['Area'],
      df_assam_16_2011_sum['Area'],
      df_assam_16_2012_sum['Area'],
      df_assam_16_2013_sum['Area'],
      df_assam_16_2014_sum['Area'])

y22 =(df_assam_16_1997_sum['Production'],
      df_assam_16_1998_sum['Production'],
      df_assam_16_1999_sum['Production'],
      df_assam_16_2000_sum['Production'],
      df_assam_16_2001_sum['Production'], 
      df_assam_16_2002_sum['Production'],
      df_assam_16_2003_sum['Production'],
      df_assam_16_2004_sum['Production'],
      df_assam_16_2005_sum['Production'],
      df_assam_16_2006_sum['Production'],
      df_assam_16_2007_sum['Production'],
      df_assam_16_2008_sum['Production'],
      df_assam_16_2009_sum['Production'],
      df_assam_16_2010_sum['Production'],
      df_assam_16_2011_sum['Production'],
      df_assam_16_2012_sum['Production'],
      df_assam_16_2013_sum['Production'],
      df_assam_16_2014_sum['Production'])                                      

plt.subplot(121)
plt.title('State-4 : Assam : [16] KAMRUP METRO (Area) :')
plt.xlabel('year -->')
plt.ylabel('area -->')                                                                      
plt.plot(x1,y11)
plt.show

plt.subplot(122)
plt.title('State-4 : Assam : [16] KAMRUP METRO (Production) :')
plt.xlabel('year -->')
plt.ylabel('production -->')
plt.plot(x1,y22)
plt.show() 
   
# plotting  Assam : [17] KARBI ANGLONG

x1 = ('1997','1998','1999','2000','2001','2002','2003','2004','2005',
     '2006','2007','2008','2009','2010','2011','2012','2013','2014')

y11 =(df_assam_17_1997_sum['Area'],
      df_assam_17_1998_sum['Area'],
      df_assam_17_1999_sum['Area'],
      df_assam_17_2000_sum['Area'],
      df_assam_17_2001_sum['Area'], 
      df_assam_17_2002_sum['Area'],
      df_assam_17_2003_sum['Area'],
      df_assam_17_2004_sum['Area'],
      df_assam_17_2005_sum['Area'],
      df_assam_17_2006_sum['Area'],
      df_assam_17_2007_sum['Area'],
      df_assam_17_2008_sum['Area'],
      df_assam_17_2009_sum['Area'],
      df_assam_17_2010_sum['Area'],
      df_assam_17_2011_sum['Area'],
      df_assam_17_2012_sum['Area'],
      df_assam_17_2013_sum['Area'],
      df_assam_17_2014_sum['Area'])

y22 =(df_assam_17_1997_sum['Production'],
      df_assam_17_1998_sum['Production'],
      df_assam_17_1999_sum['Production'],
      df_assam_17_2000_sum['Production'],
      df_assam_17_2001_sum['Production'], 
      df_assam_17_2002_sum['Production'],
      df_assam_17_2003_sum['Production'],
      df_assam_17_2004_sum['Production'],
      df_assam_17_2005_sum['Production'],
      df_assam_17_2006_sum['Production'],
      df_assam_17_2007_sum['Production'],
      df_assam_17_2008_sum['Production'],
      df_assam_17_2009_sum['Production'],
      df_assam_17_2010_sum['Production'],
      df_assam_17_2011_sum['Production'],
      df_assam_17_2012_sum['Production'],
      df_assam_17_2013_sum['Production'],
      df_assam_17_2014_sum['Production'])                                      

plt.subplot(121)
plt.title('State-4 : Assam : [17] KARBI ANGLONG (Area) :')
plt.xlabel('year -->')
plt.ylabel('area -->')                                                                      
plt.plot(x1,y11)
plt.show

plt.subplot(122)
plt.title('State-4 : Assam : [17] KARBI ANGLONG (Production) :')
plt.xlabel('year -->')
plt.ylabel('production -->')
plt.plot(x1,y22)
plt.show()

# plotting  Assam : [18] KARIMGANJ 

x1 = ('1997','1998','1999','2000','2001','2002','2003','2004','2005',
     '2006','2007','2008','2009','2010','2011','2012','2013','2014')

y11 =(df_assam_18_1997_sum['Area'],
      df_assam_18_1998_sum['Area'],
      df_assam_18_1999_sum['Area'],
      df_assam_18_2000_sum['Area'],
      df_assam_18_2001_sum['Area'], 
      df_assam_18_2002_sum['Area'],
      df_assam_18_2003_sum['Area'],
      df_assam_18_2004_sum['Area'],
      df_assam_18_2005_sum['Area'],
      df_assam_18_2006_sum['Area'],
      df_assam_18_2007_sum['Area'],
      df_assam_18_2008_sum['Area'],
      df_assam_18_2009_sum['Area'],
      df_assam_18_2010_sum['Area'],
      df_assam_18_2011_sum['Area'],
      df_assam_18_2012_sum['Area'],
      df_assam_18_2013_sum['Area'],
      df_assam_18_2014_sum['Area'])

y22 =(df_assam_18_1997_sum['Production'],
      df_assam_18_1998_sum['Production'],
      df_assam_18_1999_sum['Production'],
      df_assam_18_2000_sum['Production'],
      df_assam_18_2001_sum['Production'], 
      df_assam_18_2002_sum['Production'],
      df_assam_18_2003_sum['Production'],
      df_assam_18_2004_sum['Production'],
      df_assam_18_2005_sum['Production'],
      df_assam_18_2006_sum['Production'],
      df_assam_18_2007_sum['Production'],
      df_assam_18_2008_sum['Production'],
      df_assam_18_2009_sum['Production'],
      df_assam_18_2010_sum['Production'],
      df_assam_18_2011_sum['Production'],
      df_assam_18_2012_sum['Production'],
      df_assam_18_2013_sum['Production'],
      df_assam_18_2014_sum['Production'])                                      

plt.subplot(121)
plt.title('State-4 : Assam : [18] KARIMGANJ (Area) :')
plt.xlabel('year -->')
plt.ylabel('area -->')                                                                      
plt.plot(x1,y11)
plt.show

plt.subplot(122)
plt.title('State-4 : Assam : [18] KARIMGANJ (Production) :')
plt.xlabel('year -->')
plt.ylabel('production -->')
plt.plot(x1,y22)
plt.show()

# plotting  Assam : [19] KOKRAJHAR 

x1 = ('1997','1998','1999','2000','2001','2002','2003','2004','2005',
     '2006','2007','2008','2009','2010','2011','2012','2013','2014')

y11 =(df_assam_19_1997_sum['Area'],
      df_assam_19_1998_sum['Area'],
      df_assam_19_1999_sum['Area'],
      df_assam_19_2000_sum['Area'],
      df_assam_19_2001_sum['Area'], 
      df_assam_19_2002_sum['Area'],
      df_assam_19_2003_sum['Area'],
      df_assam_19_2004_sum['Area'],
      df_assam_19_2005_sum['Area'],
      df_assam_19_2006_sum['Area'],
      df_assam_19_2007_sum['Area'],
      df_assam_19_2008_sum['Area'],
      df_assam_19_2009_sum['Area'],
      df_assam_19_2010_sum['Area'],
      df_assam_19_2011_sum['Area'],
      df_assam_19_2012_sum['Area'],
      df_assam_19_2013_sum['Area'],
      df_assam_19_2014_sum['Area'])

y22 =(df_assam_19_1997_sum['Production'],
      df_assam_19_1998_sum['Production'],
      df_assam_19_1999_sum['Production'],
      df_assam_19_2000_sum['Production'],
      df_assam_19_2001_sum['Production'], 
      df_assam_19_2002_sum['Production'],
      df_assam_19_2003_sum['Production'],
      df_assam_19_2004_sum['Production'],
      df_assam_19_2005_sum['Production'],
      df_assam_19_2006_sum['Production'],
      df_assam_19_2007_sum['Production'],
      df_assam_19_2008_sum['Production'],
      df_assam_19_2009_sum['Production'],
      df_assam_19_2010_sum['Production'],
      df_assam_19_2011_sum['Production'],
      df_assam_19_2012_sum['Production'],
      df_assam_19_2013_sum['Production'],
      df_assam_19_2014_sum['Production'])                                      

plt.subplot(121)
plt.title('State-4 : Assam : [19] KOKRAJHAR (Area) :')
plt.xlabel('year -->')
plt.ylabel('area -->')                                                                      
plt.plot(x1,y11)
plt.show

plt.subplot(122)
plt.title('State-4 : Assam : [19] KOKRAJHAR  (Production) :')
plt.xlabel('year -->')
plt.ylabel('production -->')
plt.plot(x1,y22)
plt.show()

# plotting  Assam : [20] LAKHIMPUR 

x1 = ('1997','1998','1999','2000','2001','2002','2003','2004','2005',
     '2006','2007','2008','2009','2010','2011','2012','2013','2014')

y11 =(df_assam_20_1997_sum['Area'],
      df_assam_20_1998_sum['Area'],
      df_assam_20_1999_sum['Area'],
      df_assam_20_2000_sum['Area'],
      df_assam_20_2001_sum['Area'], 
      df_assam_20_2002_sum['Area'],
      df_assam_20_2003_sum['Area'],
      df_assam_20_2004_sum['Area'],
      df_assam_20_2005_sum['Area'],
      df_assam_20_2006_sum['Area'],
      df_assam_20_2007_sum['Area'],
      df_assam_20_2008_sum['Area'],
      df_assam_20_2009_sum['Area'],
      df_assam_20_2010_sum['Area'],
      df_assam_20_2011_sum['Area'],
      df_assam_20_2012_sum['Area'],
      df_assam_20_2013_sum['Area'],
      df_assam_20_2014_sum['Area'])

y22 =(df_assam_20_1997_sum['Production'],
      df_assam_20_1998_sum['Production'],
      df_assam_20_1999_sum['Production'],
      df_assam_20_2000_sum['Production'],
      df_assam_20_2001_sum['Production'], 
      df_assam_20_2002_sum['Production'],
      df_assam_20_2003_sum['Production'],
      df_assam_20_2004_sum['Production'],
      df_assam_20_2005_sum['Production'],
      df_assam_20_2006_sum['Production'],
      df_assam_20_2007_sum['Production'],
      df_assam_20_2008_sum['Production'],
      df_assam_20_2009_sum['Production'],
      df_assam_20_2010_sum['Production'],
      df_assam_20_2011_sum['Production'],
      df_assam_20_2012_sum['Production'],
      df_assam_20_2013_sum['Production'],
      df_assam_20_2014_sum['Production'])                                      

plt.subplot(121)
plt.title('State-4 : Assam : [20] LAKHIMPUR (Area) :')
plt.xlabel('year -->')
plt.ylabel('area -->')                                                                      
plt.plot(x1,y11)
plt.show

plt.subplot(122)
plt.title('State-4 : Assam : [20] LAKHIMPUR (Production) :')
plt.xlabel('year -->')
plt.ylabel('production -->')
plt.plot(x1,y22)
plt.show()

# plotting  Assam : [21] MARIGAON 

x1 = ('1997','1998','1999','2000','2001','2002','2003','2004','2005',
     '2006','2007','2008','2009','2010','2011','2012','2013','2014')

y11 =(df_assam_21_1997_sum['Area'],
      df_assam_21_1998_sum['Area'],
      df_assam_21_1999_sum['Area'],
      df_assam_21_2000_sum['Area'],
      df_assam_21_2001_sum['Area'], 
      df_assam_21_2002_sum['Area'],
      df_assam_21_2003_sum['Area'],
      df_assam_21_2004_sum['Area'],
      df_assam_21_2005_sum['Area'],
      df_assam_21_2006_sum['Area'],
      df_assam_21_2007_sum['Area'],
      df_assam_21_2008_sum['Area'],
      df_assam_21_2009_sum['Area'],
      df_assam_21_2010_sum['Area'],
      df_assam_21_2011_sum['Area'],
      df_assam_21_2012_sum['Area'],
      df_assam_21_2013_sum['Area'],
      df_assam_21_2014_sum['Area'])

y22 =(df_assam_21_1997_sum['Production'],
      df_assam_21_1998_sum['Production'],
      df_assam_21_1999_sum['Production'],
      df_assam_21_2000_sum['Production'],
      df_assam_21_2001_sum['Production'], 
      df_assam_21_2002_sum['Production'],
      df_assam_21_2003_sum['Production'],
      df_assam_21_2004_sum['Production'],
      df_assam_21_2005_sum['Production'],
      df_assam_21_2006_sum['Production'],
      df_assam_21_2007_sum['Production'],
      df_assam_21_2008_sum['Production'],
      df_assam_21_2009_sum['Production'],
      df_assam_21_2010_sum['Production'],
      df_assam_21_2011_sum['Production'],
      df_assam_21_2012_sum['Production'],
      df_assam_21_2013_sum['Production'],
      df_assam_21_2014_sum['Production'])                                      

plt.subplot(121)
plt.title('State-4 : Assam : [21] MARIGAON (Area) :')
plt.xlabel('year -->')
plt.ylabel('area -->')                                                                      
plt.plot(x1,y11)
plt.show

plt.subplot(122)
plt.title('State-4 : Assam : [21] MARIGAON (Production) :')
plt.xlabel('year -->')
plt.ylabel('production -->')
plt.plot(x1,y22)
plt.show()

# plotting  Assam : [22] NAGAON

x1 = ('1997','1998','1999','2000','2001','2002','2003','2004','2005',
     '2006','2007','2008','2009','2010','2011','2012','2013','2014')

y11 =(df_assam_22_1997_sum['Area'],
      df_assam_22_1998_sum['Area'],
      df_assam_22_1999_sum['Area'],
      df_assam_22_2000_sum['Area'],
      df_assam_22_2001_sum['Area'], 
      df_assam_22_2002_sum['Area'],
      df_assam_22_2003_sum['Area'],
      df_assam_22_2004_sum['Area'],
      df_assam_22_2005_sum['Area'],
      df_assam_22_2006_sum['Area'],
      df_assam_22_2007_sum['Area'],
      df_assam_22_2008_sum['Area'],
      df_assam_22_2009_sum['Area'],
      df_assam_22_2010_sum['Area'],
      df_assam_22_2011_sum['Area'],
      df_assam_22_2012_sum['Area'],
      df_assam_22_2013_sum['Area'],
      df_assam_22_2014_sum['Area'])

y22 =(df_assam_22_1997_sum['Production'],
      df_assam_22_1998_sum['Production'],
      df_assam_22_1999_sum['Production'],
      df_assam_22_2000_sum['Production'],
      df_assam_22_2001_sum['Production'], 
      df_assam_22_2002_sum['Production'],
      df_assam_22_2003_sum['Production'],
      df_assam_22_2004_sum['Production'],
      df_assam_22_2005_sum['Production'],
      df_assam_22_2006_sum['Production'],
      df_assam_22_2007_sum['Production'],
      df_assam_22_2008_sum['Production'],
      df_assam_22_2009_sum['Production'],
      df_assam_22_2010_sum['Production'],
      df_assam_22_2011_sum['Production'],
      df_assam_22_2012_sum['Production'],
      df_assam_22_2013_sum['Production'],
      df_assam_22_2014_sum['Production'])                                      

plt.subplot(121)
plt.title('State-4 : Assam : [22] NAGAON (Area) :')
plt.xlabel('year -->')
plt.ylabel('area -->')                                                                      
plt.plot(x1,y11)
plt.show()

plt.subplot(122)
plt.title('State-4 : Assam : [22] NAGAON (Production) :')
plt.xlabel('year -->')
plt.ylabel('production -->')
plt.plot(x1,y22)
plt.show()

# plotting  Assam : [23] NALBARI

x1 = ('1997','1998','1999','2000','2001','2002','2003','2004','2005',
     '2006','2007','2008','2009','2010','2011','2012','2013','2014')

y11 =(df_assam_23_1997_sum['Area'],
      df_assam_23_1998_sum['Area'],
      df_assam_23_1999_sum['Area'],
      df_assam_23_2000_sum['Area'],
      df_assam_23_2001_sum['Area'], 
      df_assam_23_2002_sum['Area'],
      df_assam_23_2003_sum['Area'],
      df_assam_23_2004_sum['Area'],
      df_assam_23_2005_sum['Area'],
      df_assam_23_2006_sum['Area'],
      df_assam_23_2007_sum['Area'],
      df_assam_23_2008_sum['Area'],
      df_assam_23_2009_sum['Area'],
      df_assam_23_2010_sum['Area'],
      df_assam_23_2011_sum['Area'],
      df_assam_23_2012_sum['Area'],
      df_assam_23_2013_sum['Area'],
      df_assam_23_2014_sum['Area'])

y22 =(df_assam_23_1997_sum['Production'],
      df_assam_23_1998_sum['Production'],
      df_assam_23_1999_sum['Production'],
      df_assam_23_2000_sum['Production'],
      df_assam_23_2001_sum['Production'], 
      df_assam_23_2002_sum['Production'],
      df_assam_23_2003_sum['Production'],
      df_assam_23_2004_sum['Production'],
      df_assam_23_2005_sum['Production'],
      df_assam_23_2006_sum['Production'],
      df_assam_23_2007_sum['Production'],
      df_assam_23_2008_sum['Production'],
      df_assam_23_2009_sum['Production'],
      df_assam_23_2010_sum['Production'],
      df_assam_23_2011_sum['Production'],
      df_assam_23_2012_sum['Production'],
      df_assam_23_2013_sum['Production'],
      df_assam_23_2014_sum['Production'])                                      

plt.subplot(121)
plt.title('State-4 : Assam : [23] NALBARI (Area) :')
plt.xlabel('year -->')
plt.ylabel('area -->')                                                                      
plt.plot(x1,y11)
plt.show

plt.subplot(122)
plt.title('State-4 : Assam : [23] NALBARI (Production) :')
plt.xlabel('year -->')
plt.ylabel('production -->')
plt.plot(x1,y22)
plt.show()

# plotting  Assam : [24] SIVASAGAR 

x1 = ('1997','1998','1999','2000','2001','2002','2003','2004','2005',
     '2006','2007','2008','2009','2010','2011','2012','2013','2014')

y11 =(df_assam_24_1997_sum['Area'],
      df_assam_24_1998_sum['Area'],
      df_assam_24_1999_sum['Area'],
      df_assam_24_2000_sum['Area'],
      df_assam_24_2001_sum['Area'], 
      df_assam_24_2002_sum['Area'],
      df_assam_24_2003_sum['Area'],
      df_assam_24_2004_sum['Area'],
      df_assam_24_2005_sum['Area'],
      df_assam_24_2006_sum['Area'],
      df_assam_24_2007_sum['Area'],
      df_assam_24_2008_sum['Area'],
      df_assam_24_2009_sum['Area'],
      df_assam_24_2010_sum['Area'],
      df_assam_24_2011_sum['Area'],
      df_assam_24_2012_sum['Area'],
      df_assam_24_2013_sum['Area'],
      df_assam_24_2014_sum['Area'])

y22 =(df_assam_24_1997_sum['Production'],
      df_assam_24_1998_sum['Production'],
      df_assam_24_1999_sum['Production'],
      df_assam_24_2000_sum['Production'],
      df_assam_24_2001_sum['Production'], 
      df_assam_24_2002_sum['Production'],
      df_assam_24_2003_sum['Production'],
      df_assam_24_2004_sum['Production'],
      df_assam_24_2005_sum['Production'],
      df_assam_24_2006_sum['Production'],
      df_assam_24_2007_sum['Production'],
      df_assam_24_2008_sum['Production'],
      df_assam_24_2009_sum['Production'],
      df_assam_24_2010_sum['Production'],
      df_assam_24_2011_sum['Production'],
      df_assam_24_2012_sum['Production'],
      df_assam_24_2013_sum['Production'],
      df_assam_24_2014_sum['Production'])                                      

plt.subplot(121)
plt.title('State-4 : Assam : [24] SIVASAGAR (Area) :')
plt.xlabel('year -->')
plt.ylabel('area -->')                                                                      
plt.plot(x1,y11)
plt.show

plt.subplot(122)
plt.title('State-4 : Assam : [24] SIVASAGAR (Production) :')
plt.xlabel('year -->')
plt.ylabel('production -->')
plt.plot(x1,y22)
plt.show()

# plotting  Assam : [25] SONITPUR

x1 = ('1997','1998','1999','2000','2001','2002','2003','2004','2005',
     '2006','2007','2008','2009','2010','2011','2012','2013','2014')

y11 =(df_assam_25_1997_sum['Area'],
      df_assam_25_1998_sum['Area'],
      df_assam_25_1999_sum['Area'],
      df_assam_25_2000_sum['Area'],
      df_assam_25_2001_sum['Area'], 
      df_assam_25_2002_sum['Area'],
      df_assam_25_2003_sum['Area'],
      df_assam_25_2004_sum['Area'],
      df_assam_25_2005_sum['Area'],
      df_assam_25_2006_sum['Area'],
      df_assam_25_2007_sum['Area'],
      df_assam_25_2008_sum['Area'],
      df_assam_25_2009_sum['Area'],
      df_assam_25_2010_sum['Area'],
      df_assam_25_2011_sum['Area'],
      df_assam_25_2012_sum['Area'],
      df_assam_25_2013_sum['Area'],
      df_assam_25_2014_sum['Area'])

y22 =(df_assam_25_1997_sum['Production'],
      df_assam_25_1998_sum['Production'],
      df_assam_25_1999_sum['Production'],
      df_assam_25_2000_sum['Production'],
      df_assam_25_2001_sum['Production'], 
      df_assam_25_2002_sum['Production'],
      df_assam_25_2003_sum['Production'],
      df_assam_25_2004_sum['Production'],
      df_assam_25_2005_sum['Production'],
      df_assam_25_2006_sum['Production'],
      df_assam_25_2007_sum['Production'],
      df_assam_25_2008_sum['Production'],
      df_assam_25_2009_sum['Production'],
      df_assam_25_2010_sum['Production'],
      df_assam_25_2011_sum['Production'],
      df_assam_25_2012_sum['Production'],
      df_assam_25_2013_sum['Production'],
      df_assam_25_2014_sum['Production'])                                      

plt.subplot(121)
plt.title('State-4 : Assam : [25] SONITPUR (Area) :')
plt.xlabel('year -->')
plt.ylabel('area -->')                                                                      
plt.plot(x1,y11)
plt.show

plt.subplot(122)
plt.title('State-4 : Assam : [25] SONITPUR (Production) :')
plt.xlabel('year -->')
plt.ylabel('production -->')
plt.plot(x1,y22)
plt.show()

# plotting  Assam : [26] TINSUKIA

x1 = ('1997','1998','1999','2000','2001','2002','2003','2004','2005',
     '2006','2007','2008','2009','2010','2011','2012','2013','2014')

y11 =(df_assam_26_1997_sum['Area'],
      df_assam_26_1998_sum['Area'],
      df_assam_26_1999_sum['Area'],
      df_assam_26_2000_sum['Area'],
      df_assam_26_2001_sum['Area'], 
      df_assam_26_2002_sum['Area'],
      df_assam_26_2003_sum['Area'],
      df_assam_26_2004_sum['Area'],
      df_assam_26_2005_sum['Area'],
      df_assam_26_2006_sum['Area'],
      df_assam_26_2007_sum['Area'],
      df_assam_26_2008_sum['Area'],
      df_assam_26_2009_sum['Area'],
      df_assam_26_2010_sum['Area'],
      df_assam_26_2011_sum['Area'],
      df_assam_26_2012_sum['Area'],
      df_assam_26_2013_sum['Area'],
      df_assam_26_2014_sum['Area'])

y22 =(df_assam_26_1997_sum['Production'],
      df_assam_26_1998_sum['Production'],
      df_assam_26_1999_sum['Production'],
      df_assam_26_2000_sum['Production'],
      df_assam_26_2001_sum['Production'], 
      df_assam_26_2002_sum['Production'],
      df_assam_26_2003_sum['Production'],
      df_assam_26_2004_sum['Production'],
      df_assam_26_2005_sum['Production'],
      df_assam_26_2006_sum['Production'],
      df_assam_26_2007_sum['Production'],
      df_assam_26_2008_sum['Production'],
      df_assam_26_2009_sum['Production'],
      df_assam_26_2010_sum['Production'],
      df_assam_26_2011_sum['Production'],
      df_assam_26_2012_sum['Production'],
      df_assam_26_2013_sum['Production'],
      df_assam_26_2014_sum['Production'])                                      

plt.subplot(121)
plt.title('State-4 : Assam : [26] TINSUKIA (Area) :')
plt.xlabel('year -->')
plt.ylabel('area -->')                                                                      
plt.plot(x1,y11)
plt.show

plt.subplot(122)
plt.title('State-4 : Assam : [26] TINSUKIA (Production) :')
plt.xlabel('year -->')
plt.ylabel('production -->')
plt.plot(x1,y22)
plt.show()

# plotting  Assam : [27] UDALGURI

x1 = ('1997','1998','1999','2000','2001','2002','2003','2004','2005',
     '2006','2007','2008','2009','2010','2011','2012','2013','2014')

y11 =(df_assam_27_1997_sum['Area'],
      df_assam_27_1998_sum['Area'],
      df_assam_27_1999_sum['Area'],
      df_assam_27_2000_sum['Area'],
      df_assam_27_2001_sum['Area'], 
      df_assam_27_2002_sum['Area'],
      df_assam_27_2003_sum['Area'],
      df_assam_27_2004_sum['Area'],
      df_assam_27_2005_sum['Area'],
      df_assam_27_2006_sum['Area'],
      df_assam_27_2007_sum['Area'],
      df_assam_27_2008_sum['Area'],
      df_assam_27_2009_sum['Area'],
      df_assam_27_2010_sum['Area'],
      df_assam_27_2011_sum['Area'],
      df_assam_27_2012_sum['Area'],
      df_assam_27_2013_sum['Area'],
      df_assam_27_2014_sum['Area'])

y22 =(df_assam_27_1997_sum['Production'],
      df_assam_27_1998_sum['Production'],
      df_assam_27_1999_sum['Production'],
      df_assam_27_2000_sum['Production'],
      df_assam_27_2001_sum['Production'], 
      df_assam_27_2002_sum['Production'],
      df_assam_27_2003_sum['Production'],
      df_assam_27_2004_sum['Production'],
      df_assam_27_2005_sum['Production'],
      df_assam_27_2006_sum['Production'],
      df_assam_27_2007_sum['Production'],
      df_assam_27_2008_sum['Production'],
      df_assam_27_2009_sum['Production'],
      df_assam_27_2010_sum['Production'],
      df_assam_27_2011_sum['Production'],
      df_assam_27_2012_sum['Production'],
      df_assam_27_2013_sum['Production'],
      df_assam_27_2014_sum['Production'])                                      

plt.subplot(121)
plt.title('State-4 : Assam : [27] UDALGURI (Area) :')
plt.xlabel('year -->')
plt.ylabel('area -->')                                                                      
plt.plot(x1,y11)
plt.show

plt.subplot(122)
plt.title('State-4 : Assam : [27] UDALGURI (Production) :')
plt.xlabel('year -->')
plt.ylabel('production -->')
plt.plot(x1,y22)
plt.show()